"enter parameter value of table"

I

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

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]."
 
I

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?

Duane Hookom said:
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


icccapital said:
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.
 
D

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


icccapital said:
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?

Duane Hookom said:
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


icccapital said:
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.
 
I

icccapital

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

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

--
Duane Hookom
Microsoft Access MVP


icccapital said:
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?

Duane Hookom said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top