Update Checkbox problem

[knawtn via AccessMonster.com]

Hello. I have an update query Update_OwnerRegistered based on a form
frmRegisterRide. The form shows a list of amusement rides owned by a company,
selected from a dropdown. Each ride has a checkbox. Some have 1 ride...some
have 50 rides...depending on which company/owner is selected. Clicking the
checkbox will mark the ride as "Registered" directly in the table [tblOwner],
which is the form's control source.

Within the tblOwner is the yes/no field IsRegistered. I want the
Update_OwnerRegistered query to mark this field as True if one or more
checkboxes from the frmRegisterRide is selected. So far, it will only do so
if more than one checkbox is selected.

My update query is setup correctly I'm sure. I've tried me.refresh and me.
requery.

I hope that made sense. Thanks in advance. Chris.

 

[karl dewey]

Where does frmRegisterRide get the data for the 50 check boxes from?
What table and fields?

 

[knawtn via AccessMonster.com]

It gets them from tblRides, which contains every ride in the state of
Maryland and their respective owner.

Incidentally, I figured out why it did not work. My control button code on
the form was set to run the update query and close the form. I deleted the
button, then added a new button control to save the record. I then added the
original code to run the update query and close the form and it worked
flawlessly. Apparently what was missing was the "save" vba. Go figure.

Thanks for responding. This forum has educated me.