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.