Open specific record in a form from a datasheet form

[eko99312]

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).
Regards

[ChipR]

Use the WhereCondition of the DoCmd.OpenForm to specify the one record you want to show.

[NeoPa]

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.