Filling an Access subform

Rattlesnake

Registered User.
Local time
Today, 13:29
Joined
Sep 19, 2002
Messages
31
hi,
I have created a form with a subform in Access 2000. The subform is connected to the main form using a autonumber field. There is a combobox on the main form that has some values(not the autonumber field). When a user selects a value from the combo box I want to display a set of records in the subform.
How can I do this?
Basically this is for the adding a record in the "Delivey Note " Module of an Inventory system. The combo box contains the Purchase orders. When the user selects a purchase order he should get all the items that were ordered to appear in the sub form.
Thanks
 
thanks.
But I already did that.
But what I want is that when a value is selected in the combo box on the main form, i want to display records in the subform from another table(based on the selection made in the combo) and not the one that is currently connected to main form.

Thanks

I Know i'm testing ur patience :)
 

Users who are viewing this thread

Back
Top Bottom