Need some help w/ "Code" behind a checkbox on a form....

  • Thread starter Thread starter JNariss
  • Start date Start date
J

JNariss

Hello,

1. Just to explain:
I have a form in my database called "Move To Production" which displays
all the "Requests" that the manager would like to move into production
off of a query. So the form design only looks like one line of
information can be displayed but when I open the form in preview it
displays my full query in consecutive rows. (Which is what I want).

2. What I added to the form:
I have placed a checkbox on the left side of this form right next to
the field "Request ID" so the manager can easily put checks next to
each ID he wants to actually move into production and then click
submit.

3. What I would like to happen:
Upon the manager clicking submit, I would like the form to somehow
check that each check box takes the Request ID it has been placed next
to and enters the "Move To Production Date" and "Authorized By" of that
ID in the it's table "tblRequestActions". And then sends an email
notifying the other managers (in my SendObject) of each request that
has been moved.

4. How can I do this the right way??

Thanks,
Justine
 
First off, the checkbox has to be matched to a field in the table for you to
be able to selectively check off certain records. Then when the user clicks
Submit, use an Update query to modify the Production dat and Authorize by
fields for all records with that selection field checked. Then use a similar
selection query to generate your email.
 
Back
Top