Doreen- Exactly. You cannot change any field in a query that's based on an expression. What is the SQL of the query, and what are you trying to update? Note that if you include the fields used in the expression, you can update the fields, and the query will re-evaluate the expression to display the new calculated value.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of rokkeee Sent: Monday, January 09, 2006 11:25 AM To: [email protected] Subject: [ms_access] subform fields to data entry I have a form with two subforms. The first subform is informational data only. The second subform is directly linked to a table for data entry. I'm having trouble with the data entry subform writing to the appropriate fields in the table. Some of the fields update and some do not. The ones that don't have a calculated field using an IIf statement and I'm wondering if this could be the problem? Doreen Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
