By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,189 Members | 2,167 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,189 IT Pros & Developers. It's quick & easy.

Clicking on record in datasheet to open a form

P: 10
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,

Nov 12 '09 #1
Share this Question
Share on Google+
1 Reply

P: 10
Nevermind, I got it figured out.

I used ="[File Number]=" & "'" & [File Number] & "'" in the where statement for the macro.
Nov 13 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.