To auto-populate a combo box based on some other criteria, I know to use a query in row source, but how do I auto-populate a text box based on some other criteria (e.g. what is selected in an existing combo box)?

Thanks

[This message has been edited by dunkingman (edited 07-05-2001).]

[This message has been edited by dunkingman (edited 07-05-2001).]

If your combobox is named "cbo", "cbo.column(1)" refers to the 2nd column in you combobox recordsource. "cbo.column(2)" the 3rd and so on. So

Me!txtbox = cbo.column(1)

etc.

Thanks for the help llkhoutx, but I couldn't get it to work. It might be better if I could find a way to turn a text box into a combo box using code. I know how to query data into a combo box, but do you know how to or if it is possible to change a text box to a combo box using code?

Thanks again