Same Form Different Query...

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

Guest

Hi, I tried searching for an answer in this group, but am unable to come up
with anything that is useful.
What I would like to do is have one form that would use the results of
different queries depending on what the user selects. Right Now I have
multiple forms with the recordsource pointing to the specific query I need
run. How do I dynamically change the recordsource of a form? Thanks in
advance.
 
Forms have a RecordSource property. In code behind a command button or some
other event, you could do something like:

Me.RecordSource = "the name of the new query"

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top