A Better Way to Fill Form Field from Combo Box

Save Multiple Values From Lookup Lists

Here's a better way to fill a field that gets its value from a combo box.  Below, we are getting the shipper's account number from the Shipper_Combo field (3rd column in the list, 2nd column counting from zero).  Notice the Control Source for the Account text box: =[Shipper_Combo].column(2).

So,  now you know the correct way to fill in a text field from values in a combo box.  No visual basic code is required!

This same technique with minor modifications can be used to display numerous fields from dropdown list boxes on the form in unbound text fields.

Download an Access database which demonstrates this Combo Box/Text Field feature. Here's an image of the demonstration download:

Additional Information Dealing with Fields on Access Forms:

Reference Nested Forms

Reference Microsoft Access Form Controls from VB Script. Have you come across the maddening task of trying to reference a deeply nested form, form field or ... www.blueclaw-db.com/access_form_reference.htm

Populate Two Fields From Drop Down List Box

Microsoft Access sample code: fill in second field from lookup list. ... Populate Two Form Fields From Drop Down List ... www.blueclaw-db.com/comboboxlist/multiple_dropdown_fields.htm

Access Field Validation Visual Basic

Date_Entered>date() then ' Date_Entered is form field name msgbox "Please enter a date less than or equal to today's date." ... www.blueclaw-db.com/formfieldvalidation.htm