Update field in record after update on checkbox

  • Thread starter Thread starter Santa-D
  • Start date Start date
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.
 
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...

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

Message posted via AccessMonster.com
 
Back
Top