471,074 Members | 1,444 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,074 software developers and data experts.

Open specific record in a form from a datasheet form

Let's say I have this form called Attendance List. The list was in datasheet form. In the list there were names and date checklist. The question is, I want to edit one of the names by double clicking on the datasheet and it will pop up Employee Form. To pop up Employee Form by double clicking on the names are easy, but the trick is I want the Employee Form shows the specific name that I wanted (or the specific name record), normally it will open the first record.
I hope my question clear enough. Help would be nice (with a sample would be grateful).
Dec 29 '09 #1
2 3209
1,287 Expert 1GB
Use the WhereCondition of the DoCmd.OpenForm to specify the one record you want to show.
Dec 29 '09 #2
32,341 Expert Mod 16PB
If you want some example code you need to provide us first with some parameters. The WhereCondition parameter is simply a string formatted as a SQL WHERE clause but without the word WHERE. At this point only you know what type of data you're even working with.
Jan 8 '10 #3

Post your reply

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

Similar topics

2 posts views Thread by Support4John | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.