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
|
|||
|
|||
Update control
Form_SomeForm.SomeField.Value = 1
Sets the value of the active/current record, since i am using a tabular form i want to set the value of the field in all the records. Thanks |
#2
|
|||
|
|||
Update control
Hi,
I am trying to do somthing like a "select all". For this i have created a button in which i have am using a macro Form_SomeForm.SomeField.Value = 1, SomeField is a CheckBox. But it sets only the active record and not all the records. Please help. "ITC" wrote in message ... Form_SomeForm.SomeField.Value = 1 Sets the value of the active/current record, since i am using a tabular form i want to set the value of the field in all the records. Thanks |
#3
|
|||
|
|||
Update control
ITC,
In order to update *all* the records with the same value use an Update Qurey, base on the relevant table and set the value of "somField" to Yes,True, or -1 (-1 is the value of True, 0 is the value of False) Regrds/JK ITC wrote: Hi, I am trying to do somthing like a "select all". For this i have created a button in which i have am using a macro Form_SomeForm.SomeField.Value = 1, SomeField is a CheckBox. But it sets only the active record and not all the records. Please help. "ITC" wrote in message ... Form_SomeForm.SomeField.Value = 1 Sets the value of the active/current record, since i am using a tabular form i want to set the value of the field in all the records. Thanks |
#4
|
|||
|
|||
Update control
Thanks, it works.
I had to do a me.refresh to ensure it refreshes the values immediately in the current view "Jacob" wrote in message ups.com... ITC, In order to update *all* the records with the same value use an Update Qurey, base on the relevant table and set the value of "somField" to Yes,True, or -1 (-1 is the value of True, 0 is the value of False) Regrds/JK ITC wrote: Hi, I am trying to do somthing like a "select all". For this i have created a button in which i have am using a macro Form_SomeForm.SomeField.Value = 1, SomeField is a CheckBox. But it sets only the active record and not all the records. Please help. "ITC" wrote in message ... Form_SomeForm.SomeField.Value = 1 Sets the value of the active/current record, since i am using a tabular form i want to set the value of the field in all the records. Thanks |
Thread Tools | |
Display Modes | |
|
|