AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
Question I have a multi-column combobox in a form that I want to have autoupdate 3 text fields. i have followed the suggestions found on the microsoft website and it works, BUT when i try it, it autoupdates all the other records in my table. FYI the combobox derives its information from 2nd table called products (other columns are itemnumber, UOM, cost). my form is called rejects
There are two issues here. As the article says you should not be duplicating data. However, at least one of your fields is one of the exceptions to this rule, that would be the Cost field. The other two controls (not fields) should be unbound and just display the related data, probably using the Column property. However, the cost control should be bound and you should populate it using the the After Update event of the combo like so:
