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
but when i click on the linkCode:Private Sub txtTancNumber_Click() DoCmd.OpenForm "frm_NewCavityTanc", WhereCondition:="[Tanc_ID]=" & Me.txtTancNumber End Sub
i get a pop up box appear asking for the Tanc_ID
how do i stop this