Update Checkbox problem

  • Thread starter knawtn via AccessMonster.com
  • Start date
K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Checkbox problem 2
Create form with checkbox les that expand and collapse sections of the form? 0
list or combo box 0
Show select table entries based on yes/no checkbox answers 1
Update checkbox on all but most recent Transaction 1
select only one checkbox 2
Update query to remove data 3
Controlling a WHERE with a checkbox 5

Top