Forum Discussion
CJDataBI
Mar 13, 2024Copper Contributor
How to populate Access query record with text from Form
I have a query which returns sales data between 2 dates (Start Date, End Date) from 2 text boxes on a form. I would like to display these 2 dates in the query (Start Date, End Date) to show wh...
Mar 13, 2024
Hi,
When you click into the seemingly empty columns, do you see kind of "chinese" characters? If yes, then this is an old bug when referencing form controls in queries. One of the workarounds is:
Eval("Forms!YourForm!YourControl")
Servus
Karl
****************
Access DevCon - online conference April 18+19
Access Forever
Access News
Access-Entwickler-Konferenz AEK