You can use the OpenArgs... from your double-click procedure, you can put this:
DoCmd.OpenForm "frmYourFormName", , , , , , & me.YourID on the form load of your another form, use the OpenArgs statement to capture the ID and populate the recordset.. HTH, George -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of bryan.leggo Sent: Monday, November 19, 2007 9:48 PM To: [email protected] Subject: [ms_access] Going from a List (Datasheet View) to a Form I'm sure this has been well covered here but it's tough getting through thousands of past questions or the MS site. I'm a new member and new to Access apps though I did some VB programming many years ago. I want to have a List object in a form that shows the entire contents of a table (Datasheet view). I already have this form done. I want the user to be able to double-click on one record and then bring up full details of that record in ANOTHER form (also this form has been designed) where the data can then be updated further. I know where to go to enter code into teh doubleclick method of the control, I think. In the old days (a la Foxpro or DBase) this would be a simple matter of recording the "current record number" and passing it a procedure to manipulate the data. What I want to do is save the "record number" and pass it to the new form so that the form will be positioned correctly on the proper record (or row). I sort-of understand concepts like methods and properties. I know that there is an FormOpen and FormActivate method for example but it's the problem of passing info (e.g. pointers to particular rows) that's confusing me. The table is indexed with a field of unique sequential integers but not auto-numbered. Any help would be appreciated. [Non-text portions of this message have been removed]
