I have a command button on a form which when clicked is supposed to open a second form to a specified criteria. Here is my code. But it isn't working. The second form is opening instead to the first record in the record source. If a record doesn't exist yet for AssetN then the form is to open for a new record entry.
DoCmd.OpenForm "frmAssetRoomDetails", acNormal, "", [AssetN] = Me.txtAssetN, , acNormal