G
Guest
Hello,
I have created a form that contains information about churchmembers and
their financial status. In the form, I created an unbound text box and tried
to use the Expression builder to take the member name from the member table
and place it in the text box.
For example:
Member Table Summary Form
Name unbound text box contains member name
Address unbound text box contains info from
other tables
City
State
Zip
I know that I could use the form design wizard to link the form to the table
however I need to input information into the form from other tables as well.
That is why I am using an unbound text box.
Here is my problem:
I create the text box, go to the expression builder and input the following:
=[Church Members]!FirstName
The above expression gives me the following error: #Name?
What am I doing wrong. Please walk me step-by-step since I am not an expert
with Access and the Expression Builder.
Thanks
I have created a form that contains information about churchmembers and
their financial status. In the form, I created an unbound text box and tried
to use the Expression builder to take the member name from the member table
and place it in the text box.
For example:
Member Table Summary Form
Name unbound text box contains member name
Address unbound text box contains info from
other tables
City
State
Zip
I know that I could use the form design wizard to link the form to the table
however I need to input information into the form from other tables as well.
That is why I am using an unbound text box.
Here is my problem:
I create the text box, go to the expression builder and input the following:
=[Church Members]!FirstName
The above expression gives me the following error: #Name?
What am I doing wrong. Please walk me step-by-step since I am not an expert
with Access and the Expression Builder.
Thanks