capture form control value for a query?

  • Thread starter Thread starter Shivalee Gupta via AccessMonster.com
  • Start date Start date
S

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.
 
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
Click to expand...
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.
 
whoever this is ....
the one who wrote my answer....
thanks...thanks...thanks a ton.
i owe u a pastry.
thanks
 
Back
Top