Requery and setting criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top