Form from a query

  • Thread starter Thread starter LG
  • Start date Start date
L

LG

I built an form that needs to be in edit mode. The form was built off a
query but I am unable to edit the information in the form.
Any ideas
 
LG said:
I built an form that needs to be in edit mode. The form was built off a
query but I am unable to edit the information in the form.
Any ideas
Click to expand...


First check to see if the query itself is updatable -- not all queries are.
If you open the query directly as a datasheet, can you update or add
records? If not, you may want to look at the help topic, "When can I update
data from a query?". That may not be the exact title of the topic, but if
you search the help file for that sentence, you should find it. Here's a
link to an online version of that article:

http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP051880011033

If your query is a totals query or uses the DISTINCT keyword, it won't be
updatable. But there are other ways of constructing queries that result in
a non-updatable query. If the query isn't updatable and you can't figure
out why after reviewing the help article linked above, post the SQL here and
maybe we can see the problem.

If the query *is* updatable, make sure that your form's AllowAdditions
property is set to Yes and that you aren't explicitly opening it read-only.
Also make sure that the database itself isn't read-only, and that you can
update records directly in the tables.
 
Open the query it's base on and see if you can edit it there. If you can,
check the form properties and see if Allow Edits is set to Yes. If not,
search on updatable queries.
 
Back
Top