New Form will not allow me to enter new records

T

tonyak

I am new to MS Access and created a new form. However, the form will not
allow me to enter new records. The is a ! sign which keeps asking me the
maximum # of records and the * is not highlighted. Simple database, but
don't know why it won't allow me to add records?
 
R

Roger Carlson

Most likely it is because the query behind the form is non-updateable.
There are many reasons why a query might be non-updateable.

Look in Hellp. To find it, type "when can I update data from a query" in
the Answer Wizard and then choose it again in the listbox below. This will
spell out when a query is updateable and when it is not.

--
--Roger Carlson
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
 
Top