FIXED LIST OF VALUES selected by tickbox

[sherCat1]

I have a table containing ID, Seat Number, and a YES/NO "occupied" field.

I've got two separate controls on a form
One control is a combo box showing the occupied seat number
this has a bound column of ID

One control is a tick box indicating whether or not the seat is occupied.

I would like to select the seat number and tick the occupied box (true)

I cant seem to keep a fixed list of seats with a current occupied value. Any help gratefully appreciated

[inspectelement]

Is there a refresh problem? Or is it that you cant check the box whatever?

[zmbd]

Query?

Open the GUI query editor
Add your table to the field
Drag your fields down to the table
in the criteria row under the yes/no field enter one of the following "-1", "True", or "Yes" (all without quotes of course)
save and execute.
This will return every record that has a true/yes value for your field.

So that we can better help you: What level of background do you have with Access and RDMS?

[sherCat1]

Good morning everyone and thanks for looking and responding to my question yesterday. I eventually discovered what was happening.

On the form which contained the two fields Seat No and true/false tick box I also had a field 'location'.

I had put an 'if' statement in an event which made the field Seat No and the true/false tick box 'not visible' when the location status was set to value 1.

This caused the record to save incorrectly.

I will make any future questions more specific but thanks for your interest, its good to know you are all out there.

[zmbd]

Thank you for following up and letting us know what happened.
Always here to help!