How can I jump to a specific record in a subform

[chrisa]

I have a continuous form to show open work orders (determined if the closedate)is null. In the form it shows me the record fine but if I click a button for more information (ie: take me to that record) it will take me to the customer but I still have to sort through records in the subform to find the open work order.
If I try to link using the workorderID, it will only work by opening the subform itself and no customer details in the main form.
What am I doing wrong? Thanks in advance.

 

[SuzieGirl]

Is the subform recordsource based on a query, which takes as a parameter the work order number from the main form, or are you using a filter to say what record you want to display on the subform?

 

[chrisa]

I use a filter based on the CustomerID in the main form

 

[Topher]

Have you tried setting up the Child and Master Link fields on the subform properties??

if you link them together with the ID field whatever Order you are on in the main form will bring up all rec's associated to that ID in the subform.

does that help?