Setting a form to allow just editing current records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to limit a form I have so it will not allow users to add a new
record - they should only be allowed to edit records already in the database.
On the other side I want to limit another form to just inputting new
records. Is this possible? If so how? Thanks.
 
Sarah,
Set one form to Allow Adds = No
The other to Data Entry = Yes
 
Here's what you can work with:

Me.AllowAdditions = True (or False)
Me.AllowDeletions = True (or False)
Me.AllowEdits = True (or False)

Could be attached to the Form Load event I suspect...
 
This works. Is there a way to have the form open with a blank record for
input?
 
Sarah,
Did you try Data Entry = Yes?
Data Entry mode only allows new records, so it forces the form to open to a blank
record.
 
I had that set to no. Is there a place that defines all the properties
available? I been trying to figure out why cycle does.
 
Sarah,
Yes. It's called Help (F1), under Text Control Properties.
 
You must log in or register to reply here.

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

Same form for new/edit record problem 4
changing form to not allow edits 2
Skip Records in a Form 2
Controlling Edits 2
synchronizing forms for same record and table 2
List Items Edit Form want to open to blank entry 6
Cant edit Access 2003 form 3
How to Partially Populate New Record 1

Back
Top