Hi - Looking for some help which I suspect will be something obvious.
I have a form that is based on a query, I am using the query as a record source so I can filter the form by a date range.
On the form I have 2 combo boxes which use 'Lookup' tables to get their values.
On the form-when I click into one of the combo boxes I get the message 'The value entered isn't valid for this field' .
If I change the record source to the table there is no problem but using the query there is, I can't quiet work out why this happening. The bound column is 1 (as per the table) and the column count is 2 (0cm;2.25cm) so I can see the descriptive text.
Would appreciate any suggestions.
RussG
I have a form that is based on a query, I am using the query as a record source so I can filter the form by a date range.
On the form I have 2 combo boxes which use 'Lookup' tables to get their values.
On the form-when I click into one of the combo boxes I get the message 'The value entered isn't valid for this field' .
If I change the record source to the table there is no problem but using the query there is, I can't quiet work out why this happening. The bound column is 1 (as per the table) and the column count is 2 (0cm;2.25cm) so I can see the descriptive text.
Would appreciate any suggestions.
RussG