capture form control value for a query?

[Shivalee Gupta via AccessMonster.com]

i am working on access-2000. my problem is :
i have a form in which i have a combo box. the user has to select a value from the combo box, which i have captured in another textbox. now i wish to run a sql query based on this value cpatured in the text box. this i am not able to do. please help.

 

[Guest]

In the where clause of the SQL Query put
Where ((table.field)=[Forms]![yourform]![yourtextbox])
group by something;

-----Original Message-----
i am working on access-2000. my problem is :
i have a form in which i have a combo box. the user has

to select a value from the combo box, which i have
captured in another textbox. now i wish to run a sql query
based on this value cpatured in the text box. this i am
not able to do. please help.

 

[Shivalee Gupta via AccessMonster.com]

whoever this is ....
the one who wrote my answer....
thanks...thanks...thanks a ton.
i owe u a pastry.
thanks