pop up form by selection

C

Confused

I am attempting to create form that has all the same base information in all
data bases but upon a selection from a combo box a different subform pops up
to complete the specific request they are inputing.
 
J

Jeff Boyce

The terminology you are using is a bit confusing, too.

What do you mean by "all the same base information in all databases"? Are
you talking about tables (the object that holds data in an Access database
file), or are you talking about multiple Access .mdb files (i.e.,
"databases")?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
C

Confused

Jeff,

What I mean is my main form uses a two databases called issues and contacts.
This form also has a combo box which offers a selection. I want a different
subform to pop-up for specific selections in the combo box (i.e. if the
selection is Facilities one form would open which belongs to the facilities
database, if the selection is Ordering it would open the Ordering database
subform and so on). Does this clear up my first message?

Bob
 
J

Jeff Boyce

Bob

In Access, the things that hold buckets o' data are called 'tables', not
'databases'. The entire .mdb file is called a 'database' in Access. I
offer these definitions so you can be assured that what you are asking for
and what folks are answering match up better.

One approach to doing what you've described would be to change the source of
the subform (by the way, another definition for Access -- a subform is a
form that is embedded within a "main form").

Thus, subforms do not "pop up". If you want a form to pop up, it's called
either a "popup form" or a "dialog box").

To get a form to pop up, use code in the combo box's AfterUpdate event that
opens the new form.

To get a different subform to "load" on your main form, again add code to
the combo box's AfterUpdate event, but this time, in the code, alter the
'source' for the subform.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
C

Confused

Jeff,

I apologize if I may have perturbed you with my lack of proper terminology.
I actually accomplished the function I was attempting to create. I am now
having an issue getting the ID fields to link after the selection is made in
the main form and the popup form opens. I thank you for any and all
assistance.

Bob
 
J

Jeff Boyce

I'm not bothered in the slightest. I only offered the clarification because
not sharing the same definitions means the answers you get may not be to the
questions you are asking.

I'm not sure what you mean by "getting the ID fields to link". Can you
clarify this?

Is the combo box's AfterUpdate event opening your "popup form"? If so, are
you using the OpenArgs syntax to pass in the ID, or are you using the popup
form's OnOpen event to "look" back at the form from which it is popping up
to gather the value of the ID?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
C

Confused

My main form (frmIssues) when it opens it assigns and Autonumber into the ID
field. The mainform also has a combo box which has different categories of
issues to put in a request for. The combo box when a selection is made it
will open other forms depending on the selection in the combo box. I used a
macro in the After update property of the combo box to open the specific form
for each selection. Each category has a different table and each table has
an ID field. I have created a relationship between the Issues table and all
other tables based on the ID field. My current problem is that when a
selection is made in the combo box the form pops up but I can not get the ID
to link in the ID field of the form so the record will save. Thanks for all
your time and patience,

Bob
 
C

Confused

Jeff,

As far as using OpenArgs syntax I have not used this syntax previsouly. I
would not know the approiate way to write out the syntax.
 
Top