I have a database I developed in which I have 3 forms created. The first
form is for customer information (name, phone, address, etc.), the second
form is for specific information on the customers specific purchase, and
the
third form is the output (which has the computed prices, taxes, etc). The
first two forms used to store the information in the customer table. The
third form reads from a query.
Not being well versed in access, I have set up a field on the first form
that allows the user to check the "Select" box. When you click on the
button
set up to close the first form and open the second form, it searches for
the
record with the "Select" field checked. The query also only pull the
records
with the "Select" field checked.
My question is how can I set up my first form so that when the "Select"
field is checked for the current record, the "Select" field for all other
records is changed to be unselected? Is there a way to do this with a
Macro?
My goal is to only have one record ever "Selected" at a time. As it
stands
now, I must go back and uncheck an records that were already checked
previously.
Any suggestions or guidance would be appreciated.
|
