Hello all,
I have an issue where queries are pulling empty values off of a form despite the fact the form has the value set.
EX:
the query "select [forms]![form_name]![field_name] as val]" returns a table with 1 column called val, and one row with a blank value.
However in the the immediate window if I type:
debug.print [forms]![form_name]![field_name] it print's the expected value that the field is set to.
I can't for the life of me figure out what is going on here or why this query suddenly stopped working.
Any help would be huge.