Good morning, I am frustrated. I have a form "frmLogProcedure" that has a field [MRNID] named "txtMRNID". I want open a second form "frmMRNUpdate" with same ID. I used the code DoCmd.OpenForm "frmMRNUpdate",,,"[MRNID] =" & Me.txtMRNID. I have checked all the different fields for accurate spelling/names. When button clicked, frmMRNUpdate opens, but the ID will not flow over.
Form Field Field Name
frmLogProcedure MRNID txtMRNID
frmMRNUpdate MRNID txtMRNID
I tried to even thought the button may be corrupt and created a new one. Any insight?