2 checkboxes on a subform 1

[cimoli]

I have 2 checkboxes on a continuous subform.
I was wondering how to make one of the checkboxes to automatically
revert to 'blank' if I choose the other checkbox.

And also both to stay blank if i don't want either checkbox, checked.
I would hate for both checkboxes to have a check.

1st checkbox is named chkCancel with a Control Sourse of Cancel.
2nd checkbox is named chkWaitList with a Control Source of Waitlist.

If neither checkbox is marked, then that means the person has a good reservation.

I thought about canning the checkbox method and use just 1 field to toggle
any of the 3 conditions but i could not figure out when a WaitList pick changes
to a good blank pick, then how to blank out the answer.

I mean, I didn't want to pick a condition for when a person is booked okay.
right now, no checkbox means they are okay to travel. Sorry for any confusion.

 

[dhookom]

I can't understand why you don't use a single combo box with a row source of a table of status. Your "Booked okay" can be the default value of the combo box.

Duane
Hook'D on Access
MS Access MVP

 

[cimoli]

Yes, I should go to a combo box and not 2 check boxes.

Question though. When I enter a "booked" record for a person who is definitely coming
on the trip, the present 'cancel' checkbox is empty correctly. In other words,
if the 'cancel' checkbox is empty, then the guy is booked for the trip.

By going to a combo box, can i make a 'blank' choice?
With 'blank meaning, he is booked. This way, during the initial input,
i just leave the combo box alone with a blank answer.
i want to avoid extra picking. 95% of the initial input is solid bookings.
So i would like to avoid having to pick 'booked' in the field and
let a 'blank' signify that the record is just fine for a booking.

I guess i should try it. If any further thoughts, please yell.

thanks. i will switch now to a combo box.

 

[cimoli]

I realize now that I can use a DEFAULT of 'Booked' in the new combo box.
This way, the inputter does not need to do anything for the 95% of the records.