I was hoping there was another way. The query the form is populated
from requires the user to put in a date and other information. So when
I run an update query, they have to enter that info again. Is there a
way to do it with coding, like next record until end of records? I
can't seem to get any code to work. I'm sure my syntax is wrong.
Regards,
Chris
Ed Robichaud wrote:
One of the easier techniques would be to have your command button run an
Update query to set the field value of the selected records to Yes/-1, then
requery your form to reflect the changed records.
-Ed
"chris" <ch**********@yahoo.comwrote in message
news:11**********************@j72g2000cwa.googlegr oups.com...
I have a form det-up as a continous form. In the Header of the form I
have a command button called "Approve". What I'm looking to do is when
the user clicks the command button all of the records in the query that
the form is populated with get a check box checked off. Can someone
tell me what that code is?
Thank you in advance.
Regards,
Chris