Can't edit query

[MadMaxx]

I might be missing something and this may be really stupid of me but how come I can't edit a query. I have another query I use which is aloowing me to add records and edit them but I created another one and it won't let me edit it in my form. The AllowEdits and Allow Additions is true in the properties menu

 

[dcx693]

Search under the Access help system for "when can I update data from a query?" Pretty comprehensive listing.

You may want to consider changing the Query's RecordSet Type to "Dynaset (Inconsistent Updates)". Be careful though, change the wrong thing (the one side of a one to many join) and you'll be left with unmatched records.

 

[MadMaxx]

That's just it. I did set it to dynaset and it still wouldn't edit. That's why I couldn't figure out why it wasn't allowing me to edit.

 

[dcx693]

Yes, but did you set it to:
"Dynaset"
or
"Dynaset (Inconsistent Updates)"
?

 

[MadMaxx]

The form that works is set to Dynaset. I never tried the Dynaset Inconsistent. WIll try after lunch.

 

[Pat Hartman]

Post your query. It is likely that there is some problem with it. Jet tries its best to make queries updatable.

 

[MadMaxx]

Thanx anyways guys but I worked around it.

cheers