Linking Main & Sub Form

  • Thread starter Thread starter Mike Wilson
  • Start date Start date
M

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
 
See the sample database "NorthWind" that comes with your
Access software. It has exactly what you need.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top