Displaying current record

[agavi]

Hi, I am a complete newbie to Access. I want to be able to double click on the field in the table, form or a query and have, as a result, another form pop-up with all the data from that record displayed. I have tried macros, but the doubleclick property only has things like goto first, last, etc. records. and always brings the first record in the table. Any hep in the right direction is greatly appreciated. Thanks.

 

[M8KWR]

try the following

DoCmd.OpenForm "NAME OF FORM YOU WANT TO OPEN", , , "[FORM THAT YOU ARE OPENING]![ID NUMBER ON FORM] = " & Me![ID NUMBER ON THE PRESENT FORM]

Hope this helps

 

[agavi]

How would I know the ID number or the current record number, though? When the end user double clicks on the form, the program snippet somehow needs to capture that number in some variable. I think... I hope.

Many thanks