Clicking on record in datasheet to open a form

[menkenk]

Good Afternoon,

I currently have an issue in trying to get a macro working for clicking a record in a subform datasheet to open a form with the complete record details of that specific record. What I used is as follows :

[File #]=[Forms]![Regular Policies]![File #]

[Regular Policies] is the subform and [Client Details] is the main form. [Policy Details] is the form I would like to open which contains all the fields for the complete record details. I attached the macro to the on click event of [File #]. It keeps asking me for a parameter when clicking on [File #] through the main form, and works fine when I click on it when [Regular Policies] is the main form. I tried this on the Where statement in the macro with no luck :

[File #]=[Forms]![Client Details]![Regular Policies]![File #]

Is there anyway to make it so that if a record doesn't exist, when a user clicks on it, it will open up the form to a blank record?

Thank you,

Ken

[menkenk]

Nevermind, I got it figured out.

I used ="[File Number]=" & "'" & [File Number] & "'" in the where statement for the macro.