Change combo box and have it update text box

[Mattress58]

I need to somehow make it where when I change my combo box (combo151-by select from the list) it populates Text186 with the total from the table. Meaning it finds the following criteria in the table and gives me the total where they all match. How can I do this? Thanks for help

Example: I select Dallas in the combo box and it automatically looks up Dallas, 12, 2009, and gives me 15 in the text186 textbox. I know if the picture I need to change Text160 textbox to 12 to match the table.

Thanks again.

[ItsMe]

It seems that you are using an unbound forms and an unbound combo. You can certainly accomplish what you need using an unbound form and controls. however, you will need to use some VBA to get the job done. Alternatively, you can bind your form to a query or a table and use your combo to Update a field in that bound table/query. You do this via the Control Source property of the Combo Control.

But, you will, first, need to adjust the Combo's RowSource, Bound Column, Column Count, and Column Widths to retrieve the data from your "first view" table. Here is a link to a Video Tutorial series. The first video in the series describes the necessary Combo properties. It is 40 minutes long.

https://www.accessforums.net/tutoria...ers-52741.html

[orange]

You should give your fields and controls meaningful names.

eg combo151 might be more meaningful as comboCity

You know your set up/environment better than readers, but better names will make things easier to debug and describe to others.

There are several tutorials re comboboxes here.

[Mattress58]

Thanks, I keep getting a compressed zip folder error when I download the video. Do you have a little more on the

"But, you will, first, need to adjust the Combo's RowSource, Bound Column, Column Count, and Column Widths to retrieve the data from your "first view" table option."

I have been trying a D lookup also and cant seem to get it to work. I look at the tutorials that orange posted above and It shows me how to populate one combo box based on another but not quite this example. Any thing yall can show me would be awesome. Ive been working thios since yesterday.

[ItsMe]

Do you have a little more on the...

I do have more information on that. The problem is that it will take a while for me to clarify and fully understand what you have in front of you. This is why I suggested that first video. It seems to me that you are working with an unbound form. Depending on what your end goal is, an unbound form may not be suitable.

I referred to that first video because it is specific to the properties you will need to consider to build your combo, retrieve data from one table and update data in a field in another table. It is the most concise approach I can imagine, at the moment.

It has been brought to my attention that WinZip will not un-Zip the compressed folders. I used Microsoft Windows to compress the folders. If you right click the compressed folder, there should be an option, from your Windows machine, to manage "Compression". I am sorry for the difficulties. I am going through trial stages of offering tutorials online.