Jan 4 2008, 03:07 PM
I have tried to enter a result from a query in the default of a form field . When the form is opened, I get the result "#Name?". Can anybody help me resolve this?
Jan 4 2008, 03:10 PM
How did you try to enter the result of a query in the default property? Did you just enter the query name?
Might want to use a DLookup statement instead.
Jan 4 2008, 03:13 PM
how would i enter that comand?
Jan 4 2008, 03:15 PM
Jan 4 2008, 03:16 PM
thanks, i will give that a try
Jan 4 2008, 03:30 PM
i tried the dlookup command and get #error
Jan 4 2008, 03:33 PM
What was the expression you used? And where did you put it?
Jan 4 2008, 03:36 PM
I have a form with a field called "odometer" and I used the following in the defaultvalue box
Jan 4 2008, 04:05 PM
i got it figured out. Thanks to all who helped me with this problem.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here