Opening a form to a specific record from a form

[rousseaud]

I have a continuous form, frmA, that lists certain record fields from tblB. I want to be able to click on one of the records in frmA (just an on click event on one of the form fields) and have that open frmC to that specific record. Does that make sense? frmA references a query of tblB and frmC references tblB directly. I've tried the following in an on click event of one of the fields in frmA and had no luck:

DoCmd.openForm "frmB" , , , "[field1] = '" & Me![field1] & "'"

Any ideas?

[cyberdwarf]

AFAIK, you don't need the single quotes, as you are not writing SQL code here.

You definitely need the double quotes around the first part of the WHERE condition ("Field1 = " & ), but you only need the double quotes around the variable if you're using a string ("Field1 = """ & VarName & """").

HTH
Steve

[rousseaud]

Thanks Steve, that worked brilliantly.

AFAIK, you don't need the single quotes, as you are not writing SQL code here.

You definitely need the double quotes around the first part of the WHERE condition ("Field1 = " & ), but you only need the double quotes around the variable if you're using a string ("Field1 = """ & VarName & """").

HTH
Steve