Add New Record / Make Existing Records Read Only

R

Ron

I would like open a form to add a new record and let the user browse existing
records without being able to modify them. How can I accomplish this?
Thanks
 
J

John W. Vinson

I would like open a form to add a new record and let the user browse existing
records without being able to modify them. How can I accomplish this?
Thanks
Click to expand...

Set the Form's Allow Additions property to Yes, and its Allow Edits property
to No.
 
M

Mike Painter

Ron said:
I would like open a form to add a new record and let the user browse
existing records without being able to modify them. How can I
accomplish this? Thanks
Click to expand...

One way would be to add a field named "UpDate" and mark it false when you
add a record.
Then use the on-;oad event to see if it is marked false and make it read
only.
 

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

Add needs to change to update, how? 1
Prevent Moving to New Record vs two Forms? 9
If I open a form, add a new record, close the form (without saving or changing records) will it stil 1
Inconsistent Add Record Performance 1
Modifying existing record from form 2
Custom Record Selector Controls that don't work like the built-inones 1
add records to table through ado 2
To open a subform only displaying a new record 8

Top