The following line of code is triggered in a click_event on a subform. I know the syntax is correct, but it prompts me for a parameter value ( the value I pass in the 'WHERE' clause i.e. Crefid )
When I type this in, it opens as expected. I know this value is correct, in my VBA code, and I'd like it to open automatically, without prompting. Any suggestions ? Thanks.
DoCmd.OpenForm "tblReferrals", , , "Referral_ID = " & Crefid