Filter Records on Form

[jer007]

I've been searching the site for this one but I can't seem to find exactly what I'm looking for.

I have a form that I want filtered so that when it opens, only the records with a check box value "true" will be displayed. at the same time, I would need to be able to enter new records with this filter on.

What would be the best method to do this? Would it be with VBA code in the On Open event?

Thanks for any help

Jeremy

 

[jryan224]

What is your data source? You can do it with a query to limit the records to the "true" value and make this query your data source. Provided the field that is T/F is on the form, records could be added that are either T or F. A requery after adding the records will then always show only the T records.

 

[jer007]

Thanks jdemmer

The query works. I'm not sure what you mean by a requery after adding records. How would that be done?

 

[jryan224]

After the save code, use me.requery. (or forms!formname.requery) This forces the query to run again, thus updating your form. You can read about it in the help.

Another useful one is "refresh".