I have run into the strangest thing.
I have a table named Workflow which I use an append query to upload data to.
I have a Query named Triggers that filters the data to be uploaded to the Workflow tbl through the Upload qry. One of the fields is named TestPeriod in which the data is determined by an expression:
TestPeriod:"2009Q3"
The expression is made to upload 2009Q3 as text into the field TestPeriod in the Workflow tbl. Ok, I run my update qry and it uploads the data into the Workflow tbl as planned.
However, I now have a form built to enter other data. The Form pulls from the TestPeriod field among other fields, but the TestPeriod field is pulling blank to the form.
The strange part is, when I open the Workflow tbl, the TestPeriod data is entered in it, but is not pulling to the form. If while in the Workflow tbl, I write over the data in the TestPeriod field (entering the exact data already in it), it does pull to the form. I tried to recreate this in a database that I can attach, but cannot duplicate the issue.
Does anyone have any idea what may be causing this?