Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 367
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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