Requery and setting criteria

[Guest]

My form opens and the underlying query runs. Then, I would like to requery a
specific control on the form with a different criteria then when the form
initially opened. I plan to run the Requery method in a Sub executed by the
form's "open form" event. I can run the Requery method but am wondering if I
can change a criteria in the Sub.

Can I?

James

 

[Shaun]

Sure you can.
An Access form has a RecordSource property that binds it to a query. Just
change this property. Changing it to nothing at all creates an "unbound"
form.