So far noone can figure this out, so I beseech you all. I have a somewhat complex data entry form with text boxes and 5-6 subforms. The form displays all the information about a particluar project. Some of the data is one to one relationship to project (text boxes), some of the data is one to many (sub forms). The data entry form has a query for a record source. The query selects all distinct (using SQL statement) records from two tables that fit input parameters. Query runs great. Form opens great. All controls can get focus great. Can navigate between records great and see all the data. Problem is you can only update data in the subform controls, not the text boxes. All data in text boxes is in one to one relationship with project. All suspect controls have locked property set to no.

the entire County of Montgomery (PA) thanks you.

(IMG:http://www.utteraccess.com/forum/style_emoticons/default/welcome2UA.gif)


Can you edit data in the query? If not, you have created an non-updatable recordset. In which case, you probably need to either create a less complex query or bind your form directly to the tables involved which may require more subforms.

HTH

I believe the DISTINCT keyword produces a non-updatable recordset.

Here's Allen Browne's article on all the reasons a query is read-only and some workarounds:

http://allenbrowne.com/ser-61.html