Sub Forms based on a query.

[blues763]

I have a search form on which I have 2 subforms that bring back search results based on a combo box selection on top of the page. Search results come back fine but I have button on both of these sub forms that needs to open record based on the subform values.

Code is

DoCmd.OpenForm "frmVacancyApproval_S1", , , "[Job_Ref]=" & Me.Job_Ref

but when I click on the button parametre box would appear asking to enter "Job_Ref" twice

Please help

 

[vbaInet]

Job_Ref doesn't exist in the query or table that's linked to the form "frmVacancyApproval_S1"