Form will not accept new information

  • Thread starter Thread starter Yaz
  • Start date Start date
Y

Yaz

My form is not performing correctly. It is linked to a
query which is linked to a table. Upon entering the form
it requests record information (i.e. domain name). Once
the records are retrieved, if you want to add in new
information, it will not let me.

Any ideas?

Please help.
thank you,
yashmeen
 
Is the query an updateable query? Is the form's Allow Additions property
set to Yes? Is Access security in place and preventing you from entering
data?
 
My form is not performing correctly. It is linked to a
query which is linked to a table. Upon entering the form
it requests record information (i.e. domain name). Once
the records are retrieved, if you want to add in new
information, it will not let me.
Click to expand...

Please open the Query in SQL view and post the SQL here. There are a
variety of reasons why a query might not be updateable.
 
If the form utilises either ComboBoxes or ListBoxes, make sure that the
corresponding tables used for the boxes have primary keys and unique IDs set
on them, else you will get a "Recordset Not Updatable" message at the bottom
of the screen.
Regards
Darren
 
Back
Top