David Lelièvre
asked on
Referring to a field in a form
I'm trying to create a query in which I'm referring to a text field in a form, but I'm getting an error:
Microsoft Access database engine does not recognize 'forms!Stats!txtFromDT' as a valid field name or expression
Why is this happening?
Microsoft Access database engine does not recognize 'forms!Stats!txtFromDT' as a valid field name or expression
Why is this happening?
SELECT *
FROM tblEmployee
WHERE [Date] between forms!frmStats!txtFromDT and forms!frmStats!txtThruDT and [WorkerID] = forms!frmStats!lstWorkID;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry about this, but just a quick question related to this..
I've made a crosstab from the query and I'm getting the error:
Do I also have to the Parameters Dialog for this? (It's a multi selection listbox)
Thanks.
I've made a crosstab from the query and I'm getting the error:
Microsoft Access database engine does not recognize 'forms!Stats!lstSelect' as a valid field name or expression
Do I also have to the Parameters Dialog for this? (It's a multi selection listbox)
Thanks.
You can't point to a multi-select list box.
Jim.
Jim.
ASKER
Thanks!
ASKER