John, Thanks for your assistance. You triggered my brain and I think I have the subform working as a data entry form from a table directly so far. I may have to change to a query. The only other problem I seem to be experiencing is in the line entries of the subform. It's placing an additional "blank" line in the data entry table and I'm wondering if that's because there's an autonumber field included as an incremental Transaction Number? While we're at it, after updating the last field of the [data entry] subform, you must hit the enter key for another line to appear because tabbing out of that field will move onto another new record. How can I change that action? I need to be able to add additional lines of products for the same customer. Doreen
John Viescas <[EMAIL PROTECTED]> wrote: Doreen- What is the Record Source of the outer form (the SQL if a query)? What is the Record Source of the subform (also the SQL, please)? And what are the settings in the Link Master and Link Child properties of the subform control? If the Record Sources are queries, open the query in Design view and choose SQL View from the View menu to see the SQL. 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 DD & RL Sent: Tuesday, December 20, 2005 4:16 PM To: [email protected] Subject: RE: [ms_access] using a subform for data editing Editing the field in the subform should trigger the update in the associated table but that doesn't happen. There are no calculations at this point. John Viescas <[EMAIL PROTECTED]> wrote: 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 SPONSORED LINKS Microsoft access database Database development software Database management software Database software Inventory database software Membership database software --------------------------------- YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] Yahoo! Groups Links --------------------------------- YAHOO! GROUPS LINKS Visit your group "ms_access" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Yahoo! for Good - Make a difference this year. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/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/
