I have an access form that has three values on it, a date picker, a spec number, and an unbound text box. These values reference a table, RUNDTE. There are only three values in the RUNDTE table.
When I go to use the converted value (from the unbound text box) which is written to my RUNDTE table, as a DLOOKUP- my query never completes if I use it for a criteria expression.
Here is what I had. DLookUp("[CONVERTED]","RUNDTE","SET=1")
There is only one row with three columns in RUNDTE and I don't understand why it won't complete the query. Can someone please help me or offer me another suggestion?