Created form, but will not allow additional records

  • Thread starter Help me please!!!!
  • Start date
H

Help me please!!!!

I have created my form and all the drop down lists in the form, but I am
unable to add additional records. It is only allowing one record. I have
tried setting the control box to allow additional, but it is still not
working. I am still learning to use Access and have a feeling that I am
missing a step somewhere. Any suggestions?
 
R

Roger Carlson

There are a number of reasons for this. The first thing to test is whether
your form is based on a table or a query. If it's a query, make sure it is
an updateable query. You can do this by opening the query itself and try to
add records. If you can do it there, but not in the form, then you know the
problem lies in the form. If you can't add records in the query, you'll
know the problem lies there.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
H

Help me please!!!!

Is there a site for anyone who is just learning to use Access and not
familiar with all the techinical terms. I am just wanting to be able to add
records to this to be able to sort in the future and find trends.
 
F

fredg

Is there a site for anyone who is just learning to use Access and not
familiar with all the techinical terms. I am just wanting to be able to add
records to this to be able to sort in the future and find trends.
Click to expand...

You can try posting in the Microsoft.Public.Access.GettingStarted
newsgroup, but for the most part, the same people who answer questions
there are also answering questions here.

In addition to Roger's suggestion about checking if the query is
updateable (if a query is the forms record source), set the Form's
AllowAdditions property is set to Yes.
Also set the DataEntry property to No.
They're located on the Form property sheet's Data tab.

If the terms "query" and "AllowAdditions" and "DateEntry" sound
foreign to you, then perhaps you should get an Access book and begin
by reading before attempting to create a database.
 
Top