Open a form at "New Record mode"?

R

Richard

Hello all,

I would like to click on a New Record button on Form A, which would open a
Data Entry Form, from which I enter the info for a new record.

All my records have a Auto-Number unique ID, so when I open the Data Entry
Form, I don't want it to display any records, I want the new form to be at
the next (latest) auto-number.

I just don't know how to get the form to open at a new record.

Thanks,

Richard
 
S

Sheila D

Open the form in Design View and set the Data Entry property for the Form to
Yes. This says to the form only allow new records to be added and
automatically opens to a blank record

HTH
Sheila
 
R

Richard

Thank you Sheila,

That's exactly what I needed.

Now I have a problem with my Next Record command button creating a new
record instead of a pop-up saying "Can't go to the specified record", which
is what it used to do. But I'll start a new thread, think I should for the
sake of ppl searching for answers.
 
S

Sheila D

Hi Richard

If this is a form to add new records only then the Next Record button
probably should change to say Add another record. You can't go to the next
record in the recordset if you are only adding new ones.

Sheila
 
B

Befuddled

Hi.

Can you provide instruction on how to select the Data entry properties. I
can seem to find where to do that

Thank you
 
J

JulieS

Befuddled said:
Hi.

Can you provide instruction on how to select the Data entry
properties. I
can seem to find where to do that

Thank you
Click to expand...
<snip>

Open the form in design view. Click the select all button in the
upper left corner to select the entire form. Click the Properties
button on the toolbar. On the Data tab, the 4th property from the
bottom in the Data entry property. Set the property to "Yes".

I hope this helps.
Julie
 
Top