Update field in record after update on checkbox

[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.

 

[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.

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.

--
Bob Heifler
My Access Program, Owner
www.myaccessprogram.com
info (At) MyAccessProgram (Dot) com

Message posted via AccessMonster.com