Combo Box Lookup vs Update - Microsoft Access Expert 1


	Back to Access Expert 1 Comments List

Upload Images Link Email

Combo Box Lookup vs Update

Nathan Jenson

3 years ago

Hey there.  Thanks again for these videos.  They are so good!

I have a question on this video: 04. Relational Combo Boxes

At about 6:45, you say that what a combo box does is it takes a value from one table and stores it in another table.  This makes sense later in the video when you show how to update the Lead Source and Shipping methods. But it doesn't seem to make sense with the customer example that you do right at 6:45.

Whereas the lead source and shipping method update the value in each field, when you select the customer, it doesn't update the value, but rather acts as a search to find the customer ID.

And yet, you went through the exact same steps.  What am I missing here?  Is it a search tool or an update tool?

Scott Axton

3 years ago

Is it a search tool or an update tool?

Both - sometimes even at the same time - but mostly it depends on your use of it.
In the case if looking up a Customer it is a search tool. You are actually searching for the CustomerID but based on the Customer Name. If you were to go back into a record and change the Customer in the Combo Box it would update the table (as well as probably goof up your data - LOL)

In the case of Shipping method lets say that I wanted you to use UPS but then started having issues with them, Now I prefer that you use Fed Ex as my preferred shipping method.

Keep in mind for both of these instances you are also updating the data being stored in the underlying table as well as what you see on the form because they are "bound" to a filed.

You could also use an "unbound" Combo Box that doesn't store data but is used as a criteria choice such as a Query.

If you had a Query where you wanted to see all customer that use UPS as their primary shipping.

	Richard Rost 3 years ago
Value List Combo Relational Combo Find Record

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 1.