[RESOLVED] Access - Run Query Based off of combo value

[SineX]

Hi guys, i'm having an issue with access xp that i know has to be an easy one to solve. I have a form with a bound combo box and an unbound text box. I want to select and item from the combo box then have a the text box populate with a value which is based off of the combo.

Here is a psuedo break-down:

1. User Clicks On [Base/Resbu] bound combo box.

2. Query fires like: SELECT [Wait Rate] from Data-Rates Where Resbu = [Base/Resbu];

3. The Vaule returned by the query is populated into the text box.

If anyone could point me in the right dirrection it would be helpful as i'm kind of an access newbie.

Many Thanks.


--------ADDITION-------
found the solution coding it just like i used to in old vb6 days (ah its been awhile)