Link to home
Create AccountLog in
Avatar of ml-sd
ml-sdFlag for United States of America

asked on

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.  ??
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

set the Data Entry property of the form to YES
Avatar of ml-sd

ASKER

It was on Yes
so, what is the problem?
did you make table1 as the record source of the form?
Avatar of ml-sd

ASKER

Yes i Did.   I dont understand why the form is doing that..  I created another form,  it worked fine...  
check the setting of

Allow Additions      the default for this property is Yes  and must be set to Yes
Avatar of ml-sd

ASKER

set to yes
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of ml-sd

ASKER

Thanks for your help....