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).
Microsoft Access is a fully capable database and it's primary limitations is the number of concurrent users it will support. Generally, we recommend a limit of 10 to 15 users.
We create databases large and small. Some of our databases help run entire small businesses. We also handle unique businesses such as flyrod manufacturing, cheese making, marina management, and cable tv inventory.
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
Field feature. Here's an image of the demonstration download:
Additional Information Dealing with Fields on Access Forms: