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.
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.