capturing combo-box value for a query

[Shivalee Gupta via AccessMonster.com]

i have a form-form1. inside i have a combobox-combo0. whenever user selects a value from within the combobox, it is displayed in the textbox also there on the form-text2.now i have a query in access itself based on 2 tables in my db.

select a.col1
from a,b
where a.name=b.name
and b.col2="value selected from the combobox".
this capturing of value from combo box for my query ,i am unable to do. please help.

 

[Jeff Boyce]

Shivalee

In your query, in design mode, add a reference to the form's control in the
Criterion for the field. It will look something like:

Forms!YourForm!cboYourComboBox

--
Good luck

Jeff Boyce
<Access MVP>

i have a form-form1. inside i have a combobox-combo0. whenever user

selects a value from within the combobox, it is displayed in the textbox
also there on the form-text2.now i have a query in access itself based on 2
tables in my db.

 

[Marshall Barton]

i have a form-form1. inside i have a combobox-combo0. whenever user selects a value from within the combobox, it is displayed in the textbox also there on the form-text2.now i have a query in access itself based on 2 tables in my db.

select a.col1
from a,b
where a.name=b.name
and b.col2="value selected from the combobox".
this capturing of value from combo box for my query ,i am unable to do. please help.

You can refer to the value in a control using this kind of
reference:
. . .
And b.col2=Forms!form1.text2