By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,390 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

<<help>> Open same form with multiple queries

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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:

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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.