If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Field referencing - Continous Form
How do you reference a specific field for update on a continous form?
Suppose I have three fields: ID, F1, F2 and the continuous form may have 20 records. If a user double clicks on F1, I want to place an "X" in field F2 for a subset of the 20 records based on the values in F1. Could someone provide a code snippet to put an "X" in F2 if F1 has a certain value like "ABC"? |
#2
|
|||
|
|||
Field referencing - Continous Form
On Thu, 27 May 2010 14:18:22 -0700, Stu
wrote: You could run an Update query. Create this query something like: update myTable set F2="X" where F1="ABC" Then in F1's DoubleClick event, write: Currentdb.Querydefs("myQuery").Execute dbFailOnError (of course you replace myObjectNames with yours) To show the changes to the underlying table, you may have to requery the form: Me.Requery -Tom. Microsoft Access MVP How do you reference a specific field for update on a continous form? Suppose I have three fields: ID, F1, F2 and the continuous form may have 20 records. If a user double clicks on F1, I want to place an "X" in field F2 for a subset of the 20 records based on the values in F1. Could someone provide a code snippet to put an "X" in F2 if F1 has a certain value like "ABC"? |
Thread Tools | |
Display Modes | |
|
|