Dependant control source

[abbers_01]

Is it possible to have a Control Source for a text input dependant on the value from a combo box?

Basically what I want to do is an if statement on a control source, if combo box = value A then control source = value A else if combo box = value B then control source = value B.

I'm thinking there has to be a way to do this in VB but I wouldn't know how to reference the control source. Or perhaps theres another way or its not possible.

Any discussion on this would be awesome.

 

[wazz]

i think the answer is yes. and how you do it, you've basically answered your own question. changing the row source of a listbox or combobox is done all the time, or maybe you know that. but if you are really talking about a textbox then i guess you'd have to change the Record Source of the entire form and then attach the control source to the textbox. but if you don't have to change the entire record source - ie, if your source is already available, then just use another textbox. maybe hide the second one then unhide after updating the cbobox.