Enter Parameter Value

[JamesJoey]

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:

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

 

[CJ_London]

are you sure you have the right table? from the field names I would expect to see something like tblExpenseTypes.

 

[JamesJoey]

Yup, that was it!

Don't get old.

Thanks much,
James

 

[Uncle Gizmo]

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

 

[CJ_London]

OP uses a similar naming convention to myself, but it was just a guess

Many of my tables are structured

tblWidgets
widgetPK
widgetName
...
...

 

[Uncle Gizmo]

OP uses a similar naming convention to myself, but it was just a guess...

Well it was a spot on, on the money guess! I think you should get some sort of award...

http://www.virtualtrophies.com/trophy/view/a808c5b9/