popup form

[Cosmo Monkey]

Ok..Newbie here...
This question might be simple, but so is my mind.
I am trying to create a simple data base that use a combobox to select customer, I then have a button to open a popup form with a one to many relationship.
Example.
Customer
Orders
I would like the popup to pull the CompanyID from the MainForm to link to the Orders form.


Having tried to search and find this answer I have found that the question seems to be simplier than the answer.

Would this be an event or a procedure?
Cosmo

[June7]

Simpler solution is a form/subform arrangement. No code required.

Otherwise, need to either filter the popup's RecordSource or move to a record on the popup that matches criteria.

Two options for filtering are

1. parameterized query as the RecordSource of the popup

2. code (I use only VBA) triggered by event such as button click.
DoCmd.OpenForm "Orders", , , "CompanyID=" & Me.CompanyID

Event code is a procedure.