Dropdown List not working

[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

 

[Jeff Boyce]

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

 

[Warman]

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]

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

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.

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

 

[Linq Adams via AccessMonster.com]

Also worth asking is what version of Access are you using? The fact that the
query for the 4th combobx works when run independently but comes up "blank"
when used as the combobox rowsource makes me wonder if you're using Access
2003.

Access 2003 with the SP3 service pack installed is buggier than the Great
Dismal Swamp! One of the most common bug reported involves comboboxes with
disappearing data! The field(s) in the cbo, in the underlying table, have
some kind of formatting in place. This is often the simple > used to force
UpperCase. Remove any formatting from the fields and things should work
short term, but the definitive solution is to install the hotfix for SP3.

If you are, in fact, running v2003 with SP3 installed, here's a link to Allen
Browne's site where you can find the latest news about these bugs, as well a
link to the Hotfix:

http://allenbrowne.com/bug-Access2003SP3.html

 

[Warman]

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.