Using a query as the record source for a form.

Question

I have a table I used to create a query which I then used as my record source for a form and it allows me to edit the form. In the same database, I did same steps for a second form, but I cannot edit that form. I checked properties etc., but I don't see any difference between the two forms. In the second form my query originally had calculation in it and removed those. Can anyone tell my why I cannot enter data in my form?

Answer 1

The usual reason you can't edit a form based on a query is becuase the query itself is uneditable. This often happens when using a multi table query. It will also happen if you use a Group By query. A calculated column alone shouldn't prevent it.

Try posting the SQL of the query so we can take a look.

Answer 2

The problem could be with the form, or with the query.

So let's test the query first. Open it, and try to edit an existing row, or add a new one. Does that work? If not, switch to SQL view and copy/paste the SQL in your next reply.

Answer 3

If you open the second query by itself, can you edit records?

If not:

• Is the second query based on more than one table?
• Did you turn on Totals in the design of the query?
• Did you set the Unique Values property of the query to Yes?