access info

[tina]

i want to make a form that shows info in subforms when i click on a name in a
combox box. HEELPPPPPPPPPPPPPPPPPPPPPPPPPPPPP

 

[Steve]

That's not the way subforms work. Forms/subforms are for one-to-many
relationships. The main form displays the one side and the subform displays
the many side. For example, suppose your database records customers and
their orders. A customer might have many orders so you have a one-to-many
relationship. The tables should look like:
TblCustomer
CustomerID
<fields about a customer such as name and address>

TblOrder
OrderID
CustomerID
<fields abouy an order such as order date and PO#>

The main form would display the data about a customer and the subform would
display a list of that customer's orders. So relating to your question, you
would want an unbound combobox to select a customer and code would take you
to that customer in the main form. When that happens, the subform would
automatically display a list of the orders for the customer you selected.

Steve
(e-mail address removed)

 

[Jeanette Cunningham]

You can use the form wizard to create the form and subform.
To get a combo box to search, use the combo box wizard.
When the wizard asks, choose the option to look up a value in the form.

Post back if you have problems with the above.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Guest]

i want to make a form that shows info in subforms when i click on a name
in a
combox box. HEELPPPPPPPPPPPPPPPPPPPPPPPPPPPPP