Enter Parameter Value

JamesJoey

Registered User.
Local time
Today, 14:10
Joined
Dec 6, 2010
Messages
642
I'm trying use a combo box based a lookup table to filter records on a continuous form.

I also in the combo box have the "All" choice to show all.
I'm using this same procedure to filter records in several other of my forms.
In fact I copies and pasted the Row Source to the ne combo box and then changed the table and field names.
Here is the select statement form the row source of the combo box:

Code:
SELECT DISTINCT ExpenseTypeID, ExpenseType  FROM tblExpenses UNION Select 0 as AllChoice, "(All)" as Bogus FROM tblExpenses;

Every time I click I get the 'Enter parameter value' for the 'ExpenseType.
I've double checked the table and the spelling is correct.
I've compared it with the other cbos that work fine and I see no difference except for the fiels and table name.

Any ideas
James
 
are you sure you have the right table? from the field names I would expect to see something like tblExpenseTypes.
 
Yup, that was it!

Don't get old.

Thanks much,
James
 
are you sure you have the right table? from the field names I would expect to see something like tblExpenseTypes.
Well I don't know how you got that Chris!

I can't even see it really, now.

I may have seen it if the table had been incorrectly​ named something like tblCountry!

Sent from my SM-G925F using Tapatalk
 
OP uses a similar naming convention to myself, but it was just a guess

Many of my tables are structured

tblWidgets
widgetPK
widgetName
...
...
 

Users who are viewing this thread

Back
Top Bottom