Multiple Queries for one form?

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

Guest

Hi there,

Is is possible to programically switch queries for a form? The purpose of doing this would be so that i can drill down viewable data based on what a user selects from a list box.

How can i do this or can i even?
 
use the after update event of the listbox to change the recordsource
property of the form:
me.recordsource = "NewQuery", the property is a string value. then use
me.refresh to see the changed data.
Carlee said:
Hi there,

Is is possible to programically switch queries for a form? The purpose of
Click to expand...
doing this would be so that i can drill down viewable data based on what a
user selects from a list box.
 
Back
Top