Recordset in a form (1 Viewer)

[Mish_h]

Hi. I have a form that retrieves a number of records from a query based on a filter.
I then have a checkbox that i would like to be checked or unchecked based on the value of one of the
attributes in the returned recordset. I was wondering how this could be done?

Thanks

 

[Dennisk]

Use the on current event, so you can run code for each record displayed.
In your case

If me!YourColumnName = YourConditionhere then
   me!YourCheckboxNameHere = True/False
else
   me!YourCheckboxNameHere = False/True
Endif

 

[Mish_h]

Thanks for that.
This works if i have the default view set to single form. However when i switch it to continuous forms then either all the checkboxes are ticked or none of them are ticked. This seems to be dependent on the value of the first record.