Simple Query

  • Thread starter Thread starter Paul Murphy via AccessMonster.com
  • Start date Start date
P

Paul Murphy via AccessMonster.com

Folks,

I need to write a little query which is used to populate the options in a combo box. The options will be based on what the user has chosen from a previous combo box.

I have got a query so far...

SELECT F_Name
FROM Funds
WHERE [Forms]![Form1]![ComboBox1]=Yes;

ie the option chosen is in a table with values Yes/No.

This returns all the F_Name's from the Funds table rather than those marked Yes???

Any help would be greatly appreciated...

Thanks,
Paul
 
inclose yes in quotes "yes"
if that don't work use double quotes ""yes""
or even triple quotes """yes"""
-----Original Message-----
Folks,

I need to write a little query which is used to populate
Click to expand...
the options in a combo box. The options will be based on
what the user has chosen from a previous combo box.
I have got a query so far...

SELECT F_Name
FROM Funds
WHERE [Forms]![Form1]![ComboBox1]=Yes;

ie the option chosen is in a table with values Yes/No.

This returns all the F_Name's from the Funds table rather than those marked Yes???

Any help would be greatly appreciated...

Thanks,
Paul
Click to expand...
 
Totally missing something here.

Is Forms!Form!Combobox1 a list of fields in the table Funds? If so, you can't
do what you have tried the way you have tried to do it. WHAT are you trying to
do? What is the content of combobox1? I am guessing it is not a list of True
and False values.
 
Back
Top