G
Guest
I want to set a default value in a form to update a table (Lets call it
TABLE_A). The value is the maximum of a single column in another table. (Lets
call it TABLE_B).
I know SQL very well but not VB. I set up the following query:
SELECT MAX(Col_1) AS (MaxCol1) FROM TABLE_A.
I then saved the query as SELMaxCol1
In the form design mode I went to "properties" for the field in question. I
went to expression builder and linked to my query. This produced the
following expression for default value:
=[SELMaxCol1]![MaxCol1]
When I use the form I get a #Name? error. I have changed all the names to
both match and deliberately not match for uniqueness. What is happening here?
Why is this simple process so difficult?
TABLE_A). The value is the maximum of a single column in another table. (Lets
call it TABLE_B).
I know SQL very well but not VB. I set up the following query:
SELECT MAX(Col_1) AS (MaxCol1) FROM TABLE_A.
I then saved the query as SELMaxCol1
In the form design mode I went to "properties" for the field in question. I
went to expression builder and linked to my query. This produced the
following expression for default value:
=[SELMaxCol1]![MaxCol1]
When I use the form I get a #Name? error. I have changed all the names to
both match and deliberately not match for uniqueness. What is happening here?
Why is this simple process so difficult?