"enter parameter value of table"

[icccapital]

I have a report based on a query where the Contacts table exists. The
contacts table has an address field. If I drag the field in from "add
existing fields" it will show the address fine. If I create a text box and
put =[contacts].[address] I get the message "enter parameter value" and the
parameter request is for contacts.

I am trying to do this with a text box so I can have address and address 2
pieced toegether in the same text box and resize itself it there is an
address2 or not.

Any thought? Thanks.

 

[Duane Hookom]

Do you have two fields named "address" in your record source of the report.
If so, change them so you have ContactAddress: Address or something similar.

If you have only one [Address] field in your report's record source, get rid
of the "[Contacts]."

 

[icccapital]

I have two tables each with an address field, that is why i was doing the
contacts.address. I don't want to change the tables field name. So are you
saying there is another way to rename it in the report?

Do you have two fields named "address" in your record source of the report.
If so, change them so you have ContactAddress: Address or something similar.

If you have only one [Address] field in your report's record source, get rid
of the "[Contacts]."

--
Duane Hookom
Microsoft Access MVP

I have a report based on a query where the Contacts table exists. The
contacts table has an address field. If I drag the field in from "add
existing fields" it will show the address fine. If I create a text box and
put =[contacts].[address] I get the message "enter parameter value" and the
parameter request is for contacts.

I am trying to do this with a text box so I can have address and address 2
pieced toegether in the same text box and resize itself it there is an
address2 or not.

Any thought? Thanks.

 

[Duane Hookom]

You can simply give them an alias in your report's record source. Try
Field: ContactAddress: Address
Table: Contacts

--
Duane Hookom
Microsoft Access MVP

I have two tables each with an address field, that is why i was doing the
contacts.address. I don't want to change the tables field name. So are you
saying there is another way to rename it in the report?

Do you have two fields named "address" in your record source of the report.
If so, change them so you have ContactAddress: Address or something similar.

If you have only one [Address] field in your report's record source, get rid
of the "[Contacts]."

--
Duane Hookom
Microsoft Access MVP

I have a report based on a query where the Contacts table exists. The
contacts table has an address field. If I drag the field in from "add
existing fields" it will show the address fine. If I create a text box and
put =[contacts].[address] I get the message "enter parameter value" and the
parameter request is for contacts.

I am trying to do this with a text box so I can have address and address 2
pieced toegether in the same text box and resize itself it there is an
address2 or not.

Any thought? Thanks.

 

[icccapital]

Of course, I see what you are saying. I tried it and worked great. Thanks.

You can simply give them an alias in your report's record source. Try
Field: ContactAddress: Address
Table: Contacts

--
Duane Hookom
Microsoft Access MVP

I have two tables each with an address field, that is why i was doing the
contacts.address. I don't want to change the tables field name. So are you
saying there is another way to rename it in the report?

Do you have two fields named "address" in your record source of the report.
If so, change them so you have ContactAddress: Address or something similar.

If you have only one [Address] field in your report's record source, get rid
of the "[Contacts]."

--
Duane Hookom
Microsoft Access MVP


:

I have a report based on a query where the Contacts table exists. The
contacts table has an address field. If I drag the field in from "add
existing fields" it will show the address fine. If I create a text box and
put =[contacts].[address] I get the message "enter parameter value" and the
parameter request is for contacts.

I am trying to do this with a text box so I can have address and address 2
pieced toegether in the same text box and resize itself it there is an
address2 or not.

Any thought? Thanks.