Update field in record after update on checkbox

S

Santa-D

I have a master form with information that relates to a certain asset
which is obtained from a query.

What I've been trying to do is have a checkbox on the form that
updates a specific record [ISPOOL] in the [MAIN] table if I select the
check box to identify the vehicle as a "POOL VEHICLE".

What is the easiest way to do this?

The query that I'm obtaining the data from is read only.
 
H

heifler via AccessMonster.com

Make the data type in the table to yes/no then make the checkbox data source
that field name and it will update the data table field (providing it is of
the yes/no data type.
See signature if you should need more involved help.

Santa-D said:
I have a master form with information that relates to a certain asset
which is obtained from a query.

What I've been trying to do is have a checkbox on the form that
updates a specific record [ISPOOL] in the [MAIN] table if I select the
check box to identify the vehicle as a "POOL VEHICLE".

What is the easiest way to do this?

The query that I'm obtaining the data from is read only.
Click to expand...
 
Top