Linking Main & Sub Form

[Mike Wilson]

Hi

I would be grateful if somebody could help me out.

I am trying to put together an order entry database in Access 97 that
uses a main form [Orderheader] and a sub form [ProductHdr]

I am trying to link the order details and the product details together.

I have an auto number in the Orderheader table titled OrdrId and a an OId
in the subform. I would like to transfer the OdrId to multiple selections
in the subform.

Product selection is made via linked combo boxes in the form OrderHeader
then transferred via a command button called Add to the sub form
ProductHdr.
The table names have the same names as the forms.


Any suggstions much appreciated.



Mike

 

[Van T. Dinh]

See the sample database "NorthWind" that comes with your
Access software. It has exactly what you need.

HTH
Van T. Dinh
MVP (Access)