PDA

View Full Version : Accessusei and VBA



JenkinsP€Rep
07-20-2010, 07:09 AM
I'm VERY new at vba and somewhat in access. I have a project using 3 tables and a form with a few combo boxes that read records from 1 table, the user selects the item from the list, (there are about 5 combo boxes on the form) and then writes the information from the form to a main table. So far I can create the forms and combo boxes but the selected items are not written to the main table. Do I really need vba to write the data from combo boxes to a table from a form or am I missing something. Thank you

OBP
07-20-2010, 07:16 AM
No you do not need VBA to write Combo selections to a table.
Provided that the Fields form the table are on your Form, (they can be hidden i.e. set Visible = No).
All you need to do is set the "Control Source" property of the Combo to the field that you want to store the data in.