Combo Box & Sub Form

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

Guest

I have two forms. One that has a combo box, where I select the necessary
key. The second form displays all data associated to that key (from another
table).

The two forms work perfectly, until I attempt to put the second from as a
sub form on the first form.

Now, when I select the appropriate key, the sub form will not display the
information.

Not sure how to fix this problem.

Thanks in Advance,
Elena
 
You are probably missing the parent child relationships.
Have you tried using the wizrd to insert the subform on your form? It will
ask which fields match on both forms, and set up the relationships for you.
HTH
Mich
 
Make sure your toolbox is showing (View, Toolbox)
The second item on the toolbox is a magic wand, which looks like a backslash
and four little stars. This should be selected.
Open your form in design mode. Select the item that shows
"subform/subreport" when you move you mouse over it - it's a rectangle with
lines and two tiny squares in it.
Click your mouse on your form and drag until you create a square the size of
your sub-form. The wizard should prompt you to complete the process.

Try it using your current sub-form, then do another one on your same form
letting the wizard choose items from the table. Then compare the properties
of the sub-forms to see what you may have missed by inserting your own
sub-form.

HTH
Mich
 
Back
Top