Connecting Tech Pros Worldwide Forums | Help | Site Map

<<help>> Open same form with multiple queries

Chuck
Guest
 
Posts: n/a
#1: Nov 12 '05
I appreciate any help!!!

I have an application that has 4 different forms that display the same
information except for the fact that they are fed from 4 different
parameter queries. The 4 different forms are activated by 4 different
buttons on the main switchboard. Of course, this makes me change 4
different forms when I make a change to any of them.

Is there anyway to open one form from different queries when different
buttons are pressed on the switchboard.

Thanks
Chuck

Pavel Romashkin
Guest
 
Posts: n/a
#2: Nov 12 '05

re: <<help>> Open same form with multiple queries


Totally! The only thing you need to do is to replace the form's Record
source property in the code that launches the form, which is located in
the Click events of your launching buttons on the switchboard:

For launching the form with the first query as the source:

DoCmd OpenForm "DaughterForm"
Forms!DaughterForm.RecordSource = "QueryName_1"

Others are identical to this but with the different query names.
Pavel

Chuck wrote:[color=blue]
>
> I appreciate any help!!!
>
> I have an application that has 4 different forms that display the same
> information except for the fact that they are fed from 4 different
> parameter queries. The 4 different forms are activated by 4 different
> buttons on the main switchboard. Of course, this makes me change 4
> different forms when I make a change to any of them.
>
> Is there anyway to open one form from different queries when different
> buttons are pressed on the switchboard.
>
> Thanks
> Chuck[/color]
Closed Thread


Similar Microsoft Access / VBA bytes