Subform to show records of Listbox

[gbmarlysis]

Hi,
the form is a main form to the orderdetails table. on the form there are two listboxes one is attached to the CustomerTable one is for the StoreTable then the other fields are what was ordered how many etc that fill the OrderdetailsTable. When i pick the customer in the listbox i want all the cust. orders to show up in a subform so i can see what new orders still need to be entered for that customer.
TY
Luke

[June7]

Subform is on this main form?

That arrangement is the reverse of conventional design but if it suits your needs ... try:

Set criteria for customer ID of the subform recordsource to the listbox. Then in AfterUpdate event of the listbox, requery the subform. Actually, the requery needs to refer to the subform container control. I always give the container a name different from the object it holds.

[gbmarlysis]

Hi,
not a list box actually a combo box. Cause the combo box is attached to a different table than the mainform, i cant get anything to work. I'm glad ur a VIP heres what i'm trying to do. i have a orderId form connected to orderId table. On this form i have a customer combo box linked to customer table and a store combo box linked to a store table. If its a new store or customer i have buttons that link to those forms. when i add a new order details entry it also adds the customer id and store id as they are in the order id table (foreign key). but to try and get the subform that is connected to the customer combo box thats not connected the main form is proving difficult..
What do you think, am i making sense??
TY

[June7]

Not clear. Why doesn't work - error message, wrong results, nothing happens?

Doesn't matter what table is RowSource of the combobox. Is the combobox on the main form? Show the SQL statement of the combobox RowSource.

[gbmarlysis]

Hi,
Here is my db, i would like the racedetails form to have a subform that shows an athletes racedetails when their name is picked in the top combobox.
Thankyou
Database1.zip

[June7]

You are binding main form and subform to the same data source. This won't work. You might try a split form design. Or a single normal form with unbound search boxes in form Header and records in Detail.