Dropdown List not working

  • Thread starter Thread starter Warman
  • Start date Start date
W

Warman

I have 4 dropdown lists on my form. Each is based on the preceeding lists.
The first 3 work but the fourth comes up blank.

All 4 queries work fine.

Thanks
 
Is there a question?

Since we aren't there, it might help us in diagnosing your situation if you
provided the SQL statements for those four comboboxes...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
SELECT DISTINCTROW [qryUnits].[Unit],[Unitdesc] FROM [qryUnits];
SELECT DISTINCTROW [qryFinc].[Finc],[FincDesc] FROM [qryFinc];
SELECT DISTINCTROW [qryDept].[Cost],[CostDesc] FROM [qryDept];
SELECT DISTINCTROW [qryExp].[Exp],[ExpDesc] FROM [qryExp];

All of these refer to a different query. All of the queries work but when I
use them in the Form, the first 3 return data but the fourth one returns
blanks.

If you need more info, let me know.
 
Thanks for the clarification.

Now, we'll probably need to see the SQL for those queries, too.

(is there a chance that your underlying data includes at least one "lookup"
data type in a table? -- this can confuse how you use comboboxes in forms)

Regards

Jeff Boyce
Microsoft Office/Access MVP


Warman said:
SELECT DISTINCTROW [qryUnits].[Unit],[Unitdesc] FROM [qryUnits];
SELECT DISTINCTROW [qryFinc].[Finc],[FincDesc] FROM [qryFinc];
SELECT DISTINCTROW [qryDept].[Cost],[CostDesc] FROM [qryDept];
SELECT DISTINCTROW [qryExp].[Exp],[ExpDesc] FROM [qryExp];

All of these refer to a different query. All of the queries work but when
I
use them in the Form, the first 3 return data but the fourth one returns
blanks.

If you need more info, let me know.


Jeff Boyce said:
Is there a question?

Since we aren't there, it might help us in diagnosing your situation if
you
provided the SQL statements for those four comboboxes...

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
Click to expand...
 
You are correct. I am still on v2003. Hope to update to v2007 soon. I will do
as you have instructed and hope for the best for now.
 
Back
Top