To ready for new record next time form is opened

D

datin

Hi,
Im trying to view form as ready for new record everytime I opened the form
and when Viewing data,I locked data so User cant edit data unless they click
the button.i used different form.
My problem
1) how to ready for new record when form is opnened?
2) how to locked the data

thank you and regards
 
A

Allen Browne

Open the form in design view, and set the properties of the form (not
controls.)

On the data tab, you can set AllowEdits to No to stop the user editing
existing records. You might want to set AllowDeletions to No as well.

If you set the form's DataEntry property to No, the form won't show any
existing records. It will open ready to enter a new record.
 
D

datin

I set the form's DataEntry property to No .
but the form still shows the 1st record.
I tried few form properties to see the results, but I failed.
 

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

Similar Threads

Need new record on focus 2
Macro doesn't work first time form is opened. 2
Unremovable horizontal scroll bar on subform 1
DMax on existing record to increment serialized # fails 1
How to clear the previous data 1
Special view of form for users 1
The newly created record is now shown in the form 3
Want to open a form and it be ready for a new record 2

Top