Automatically fire the next listbox...

[drblackard]

I have a list box that contains rates (Standard Rates: $350.00; Silver Rates: $450.00; Gold Rates: $500.00)....when I select the rates (Standard, Silver, or Gold) , I want the cost of the rates to show up in the next text box. The text box is a list box and does not refer to a table that I created. It is a list that I created on this list box. Is there someway that I can link the two boxes together and work together...click on rates and get cost.. Thanks in advance

 

[missinglinq]

Sorry, but

The text box is a list box

makes no sense! An object can be a text box or a list box, but it can't be both! Try you explanation again, please, so we can help.

 

[drblackard]

Disregard...got it!

 

[drblackard]

This is what I did to fix it:

I have two list boxes....both containing my list of Standard, Silver, and Gold names and prices....I copied the package box (which contained a list of these plus prices in two columns that I typed in using the form wizard/lookup feature)...pasted it onto the form and changed the name of the box to "Package Amount"....then I made one box referr to the bound column 1 and the other referr to bound column 2...now they work together perfectly...when one changes the other changes....