• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 368
  • Last Modified:

Access 2003 Form- only add records

Is there a property on a form would only allow new records on the form. I have a table  and 1 form.  when I open the form it will only allow a new record to be added.  I am assuming its a form property.  I am opening the form without any vba coding or macros.  ??
0
ml-sd
Asked:
ml-sd
  • 4
  • 4
1 Solution
 
Rey Obrero (Capricorn1)Commented:
set the Data Entry property of the form to YES
0
 
ml-sdAuthor Commented:
It was on Yes
0
 
Rey Obrero (Capricorn1)Commented:
so, what is the problem?
did you make table1 as the record source of the form?
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
ml-sdAuthor Commented:
Yes i Did.   I dont understand why the form is doing that..  I created another form,  it worked fine...  
0
 
Rey Obrero (Capricorn1)Commented:
check the setting of

Allow Additions      the default for this property is Yes  and must be set to Yes
0
 
ml-sdAuthor Commented:
set to yes
0
 
Rey Obrero (Capricorn1)Commented:
then, that form is corrupted. just delete the form and create a new one.
0
 
ml-sdAuthor Commented:
Thanks for your help....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now