Hi Guys, I'm trying to open a form to a specific record, I have a navigation form with a button and text box where i can input the specific record number, although the form opens, it always opens to a new record, I'm using the following to open the form.
DoCmd.OpenForm "frmDeliveryNote", acNormal, "", "[DeliveryNoteID]=[Forms]![frmDNote]![txtSearchDNote]", , acNormal
can anyone throw some light on why the from doesn't open to the specific record.
Cheers
DoCmd.OpenForm "frmDeliveryNote", acNormal, "", "[DeliveryNoteID]=[Forms]![frmDNote]![txtSearchDNote]", , acNormal
can anyone throw some light on why the from doesn't open to the specific record.
Cheers