Form On Load event question

[SpiritedAway]

Hi,

My form [FrmMsg] is a continuous form - I have a check box - when the user clicks on it the fields in that record are disabled - effectively meaning job done.

However, it means I don't need those records loaded when the user opens the form next.

is there a way on the forms On load event to load only those records where the check box are still false and Not load those where the check box = true.

Any help on this is much appreciated as always.

 

[boblarson]

Just use a QUERY instead of the table for the form's record source.

SELECT * FROM YourTableNameHere WHERE YourFieldName = False