forms---link between 2 combo boxes and a textbox,.

[redblaze]

hi im new to this site, and i was wondering if anybody could help me. i need to link 2 combo boxes to a text box. basically what i want is a set of options to be displayed in a combo box, but only once the first combo box has been selected. then once both are selected, the ID automatically appears in the text box. but how do i do this??

 

[Jack Cowley]

I am not completely clear on what you want but it sounds like you want the first combo box to filter the second combo box and then whatever item is chosen in the second combo box will put a value into the text box. If that is the case then this article will show you how to 'synchronize' the two combo boxes.

http://support.microsoft.com/support/kb/articles/Q209/5/76.ASP?LN=EN-US&SD=gn&FR=0&qry=q209576&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

Once this is done then code like this in the After Update event of the second combo box should give you your answer:

Me.TextBoxName = Me.ComboBoxName

Of course how you have your 2nd combo box set up will determine if the line of code above is appropriate in your situation.