Unbound Checkbox not repainting

[Epax]

I have a form with 6 unbound checkboxes, 6 comboboxes, 1 button in the header and several bound fields in the detail section.

When a user clicks the button, VBA code runs that generates SQL based on which critera ( 6 comboboxes ) then the SQL is passed in to the RecordSource of the form and a Requery is called. this all works.

The checkboxes are used to either add or remove certain critera.

What I'm trying to do is get the checkboxes to show a check in the box when I change the data in the combobox. This only works if i have run the Query to display the data at least once. After this the Checkboxes work.

Any thoughts on how I can have this work without hitting the database first?

 

[boblarson]

Since your checkboxes are unbound, they actually don't show a value unless given one, so they will show not checked, but not unchecked either. If you want them checked by default, set them to true when the form loads. I'm not sure if that is when you actually want them checked. If you want it checked when the combo box is updated, place the checkbox = True in the AfterUpdate event of the combo box.