By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,186 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Command Button - On Click Event

P: n/a
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

Dec 13 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Dec 13 '06 #2

P: n/a
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
Dec 18 '06 #3

P: n/a
2 possible solutions:

1- put your filter fields in the form header as unbound controls

2-use a pop-up form to gather the filter criteria before loading the
main form

-Ed

"chris" <ch**********@yahoo.comwrote in message
news:11**********************@j72g2000cwa.googlegr oups.com...
>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.googleg roups.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

Dec 24 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.