How to limit data in combo box? 1

[BCarruth]

I have 2 controls on a form, one is a text box called "teams", the other is a combo box called "channels".
I want to be able to limit the data in the channels control to the team in the team control. The tables involved are
Teams with fields teamname
Channel with fields channel and teamname, there may be a team with 3 channels tied to it.
What I want to happen is when the form opens and a team name appears for instance "Boston", then the only things I want to see in the channels combo box is the channels tied to Boston. I can get this correct when I open the form but when I go to another record the combo box values don't change. Any help would be appreciated

Thanks
Bob

 

[PHV]

Try to ReQuery the combo in the OnCurrent event procedure of the form.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PHV]

Try to ReQuery the combo in the OnCurrent event procedure of the form and in the AfterUpdate event procedure of the textbox.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[KenReay]

See FAQ on Combo box dependant on another combo box in the forum, it explains how to do this

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK