Update control

I

ITC

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
 
I

ITC

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.
 
J

Jacob

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
 
I

ITC

Thanks, it works.

I had to do a me.refresh to ensure it refreshes the values immediately in
the current view
 
Top