Form Field Hyperlink to open record in another form

[stuart_roberts]

hi

i am trying to open a record from a sub form into another form by clicking on a hyperlink

the sub form is bound to a query

here is my code

Private Sub txtTancNumber_Click()
    DoCmd.OpenForm "frm_NewCavityTanc", WhereCondition:="[Tanc_ID]=" & Me.txtTancNumber
End Sub

but when i click on the link

i get a pop up box appear asking for the Tanc_ID

how do i stop this

[June7]

Cross posted https://www.access-programmers.co.uk...d.php?t=299684

And answered.