Can not update data on a query based form

  • Thread starter Thread starter Arbys4131
  • Start date Start date
A

Arbys4131

I cannot update data in a query based form. The properties are set for
update but the form will not accept changed data.
 
Post the SQL statement of the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Arbys4131 said:
I cannot update data in a query based form. The properties are set
for update but the form will not accept changed data.
Click to expand...

Many queries are not updatable. Some can be tweaked so that they are, some not.
 
You must log in or register to reply here.

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

Similar Threads

Parameter Value error in a Subform 0
Query Parameter using multiple options 0
Display Form based on Query - Sorting Issue 6
Save or Update command 2
Access Access Report Works on One Machine but not Another 3
Recordset Not Updatable 2
update data in table through form 3
Using the "Forms Object" on more than field in a query table 2

Back
Top