Form will not accept new information

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
 
K

Kevin @ 3NF

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?
 
J

John Vinson

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.

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.
 
D

Darren

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top