Cascading Combo's and Text Boxes

[mousemat]

Hi

Having a mental block here

I have an unbound form with two Unbound Combo Boxes. The first is for Customers and the Second is for Sites. Customers can multiple sites)

The second combo box is synch'd with the first so only the sites relating to that customer are displayed in the drop down.

What I want to do now is to have a txt box on the unbound form to display the site address details once the second combo box has been populated.

Maybe I've been scratching my head too much as I can't seem to get my head around this (more than likely simple) problem.

 

[boblarson]

Check out my sample here for how to include info in the combo (although not shown) and use it in a set of text boxes.

 

[mousemat]

Bob

Thanks for that. I knew it must have included some VBA.

 

[boblarson]

It does not have to though. You can set the text boxes to just refer to the combo box column.

 

[mousemat]

Ah right. I'll have a play in the morning I think. Too much heat here today