Expression Builder and Queries

johntology

Registered User.
Local time
Today, 09:47
Joined
Apr 20, 2011
Messages
16
Hello,

I have a form where I want the default value of one field to be based on a query to a table. So in Default Value for that field's properties, I enter Expression Builder and select an existing query that I have successfully run and which I know works.

In Expression Builder I double-click on the name of my query. This populates the other panes of the builder and also builds an expression in this format:
[NameOfQuery]![NameOfField]

Assuming this is what I want, I hit Ok, and see the expression in the Default Value property of my form field.

But when I go to enter a new record I'm getting an error. The form is showing #Name?

Obviously the results of the query are not populating the box. What am I missing?

Thanks.
 

Users who are viewing this thread

Back
Top Bottom