Run several Queries from one Form

S

SG

I have an old database which I am rebuilding to try and condense some of the
forms.
My thought is that I would like to create one Form and from that for be able
to query out different types of information. We use this in meeting and need
to change data as we discuss things so thats why we use a form. I need to
look at Pending, Work in Progress, etc. from this form. Instead of creating
a duplicate form for each one how can I just have one form that will query
out in different ways is this possible?
 
K

Klatuu

Yes, that is no problem at all, assuming all queries are returning the same
field names to the controls. You can change the record source or modify
filtering and ordering using VBA. See Help in the VBA editor for the
RecordSource, Filter, and FilterOn properties.
 
Top