pop up form to open one record with dlookup

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
 
D

deb

I answered my own question... I was having a duh moment...

Set the default view to single form
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top