3 Combo Boxes and 1 Text Box

[Kevsim]

My database contains 4 Tables, 1 Query, 3 Combo boxes and 1 Textbox.
Using the Query, when I select an item from the first combo box, (table 1) the second comb box (table 2) only displays what is related to the first combo box, the third combo box (table 3) only displays what is related to the second combo box. All this works OK. My problem is, after selecting the data in the third combo box , there can only be one correct answer for the text box (table 4). How does this answer appear in the text box?
I would be grateful for any assistance.
Kevsim

 

[Gzep]

Hi.

If you add me.txtBox = me.cboNumber3 to the after update event of me.cboNumber3, that should do it.

if the data source of combo number 3 has more than one column, ie: index, text then use:
me.txtBox = me.cboNumber3.Columns(1)

Gzep.

 

[Kevsim]

Gzep,
Thank you for the reply, however, I did not explain the problem correctly. When I make a choice in the 3rd Combo Box and I had a 4th Combo Box, there would only be one choice in the 4th Combo Box. I need the same thing for the Text Box, I make the choice in the third Combo Box, and want the single choice the 4th Combo Box would have to be in the Text Box.
hope this makes sense.
Regards,
kevsim