pop up form to open one record with dlookup

  • Thread starter Thread starter deb
  • Start date Start date
D

deb

I have a pop up form that uses dlookup to autopopulate a couple of fields.
The user then fills in the "notes" field. He is allowed only this one note.

My issue is...
The form opens with the recordset with the dlookup fields, the field for the
user to complete and an additional empty recordset (new record). How can I
get it to open with only the recordset that the user has to complete. Do not
show a new recordset, only show the recorset with the dlookup data and
"notes" field.

I tried setting Fetch Defaults to No - didn't work
I tried allow aditions to No - didn't work
 
I answered my own question... I was having a duh moment...

Set the default view to single form
 
Back
Top