redblaze
01-12-2002, 07:16 AM
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
01-12-2002, 11:11 AM
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.