I have a form that has text box:[ID]
I want to open Continuous form : to records with [RepId]=[ID]
Currently I use [Combo3] to filter the query the form is based on using [RepID] ( [forms]![Frm2_RepQuota].[Combo3] )
I went to the Baldy Link ( http://www.baldyweb.com/wherecondition.htm ) and came up with:
Code:
Private Sub Command116_Click()
DoCmd.OpenForm "Frm2_RepQuota", , , "Combo3 = '" & Forms!EditRep.ID.Value & "'"
DoCmd.Close acForm, "EditRep"
End Sub
I have tried it with and without '
On Click I get text box asking for a parameter value for Combo3