Doreen- What triggers this update? An event on the outer form? Something the user does on the subform? Are you trying to calculate something?
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, December 19, 2005 8:09 PM To: [email protected] Subject: [ms_access] using a subform for data editing I'm having a problem trying to update a subform field with new data that will directly update the underlying table. The form shows the updated field but how do I get it to make the change in the table? I have attempted to use the "on change" and "after update" to no avail. Can I do this with a macro? I'm too rusty with VBA... Thanks, Doreen Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/2jUsvC/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> 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/
