Can't update fields on continuous form...

[Guest]

I have a form that is set up as a Continuous Form. It's based on a query
which has multiple tables joined together. The Views Allowed property is set
to Both, Allow Edits is set to Yes (I only want to allow updates, not
additions or deletions). None of the fields are locked, they're all enabled.
For some reason Access is not allowing me to update any of the fields. I open
the form with this:

DoCmd.OpenForm "frmGetExportCodesZeroFee", , , "DoctorName " & inClause

The 'inClause' variable has an IN clause built so that the recordset is
limited to only the Doctors in the IN clause. The form opens fine, showing
only the appropriate Doctors, but it won't allow me to update the values.
I've looked at everything I can think of. I do this with another form in my
application and it works fine. Any help is appreciated!

Jim B

 

[ruralguy via AccessMonster.com]

It sounds to me like the Recordset of the form is not updateable.
http://allenbrowne.com/ser-61.html

 

[Guest]

Thanks, the query uses a DISTINCT clause, that's what the problem is.

 

[ruralguy via AccessMonster.com]

Can you do it without the DISTINCT clause?

Thanks, the query uses a DISTINCT clause, that's what the problem is.

It sounds to me like the Recordset of the form is not updateable.
http://allenbrowne.com/ser-61.html

[quoted text clipped - 15 lines]