Hello, I'm trying to open a form with a particular recordset via a record id passed in like this:
DoCmd.OpenForm "DMR Tracking_Edit", , , "[DMR#] =" & NewMDRNumber & ""
When the above executes I'm asked to provide the record id. The user will not know the record id as the record was just created in another process.
How can I pass the record id to open a specific record on a form?