Inserting a new text box into a report

Hi,

I looked through your forums and didn't see this question answered. Forgive
me if it is already there and I couldn't find it.

I have a report that I want to add a new text box to. When I create a form
there is no problem choosing the different control sources of data that I
want to put into the text boxes on the report. However, once I have created
the report I can't seem to go back and make the data come through correctly
if I am adding a new text box.

Example: I want to add a text box that is pulling through data from a field
named "Duty" in a table named "Container_Vendor_Information". I put the text
box into the created form and navigated through the control source choices to
get the text box to point to where I want it to. Something goes wrong after
that. When I close the form and try to reopen it I get a pop up box that is
asking me to enter the parameter values for "Container_Vendor_Information."

I know there has to be an easy way to do this. All I'm doing is looking to
add a new text box to an exsisting form. Any thoughts would be most welcome.

I would attach the database but I guess I don't have enough posts yet to have
that option.

Thanks

Eddie.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200703/1

Thank you very much for your quick reply. I just figured out the answer when
your email popped up.

Forgive me if it was rude to comment about posting the attachments. There
was no malice behind the statement.

I am new to access and I'm sure I will other posts in the future. I look
forward to hearing your advice.

Thank you again.

Eddie.



Marshall Barton wrote:
I looked through your forums and didn't see this question answered. Forgive
me if it is already there and I couldn't find it.
[quoted text clipped - 17 lines]
I would attach the database but I guess I don't have enough posts yet to have
that option.

A text box's control source can only refer to fields in the
form's Record Source table/query.

You did not say what the form's record source is or where
the data you want to retrieve is stored, but it sounds like
you are trying to get to a different table. If so, there
should be some kind of relationship between the two tables.
If that is also the case, then the form should use a record
source query that joins the two tables or, occasionally, the
DLookup function can be used in a text box expression.

Because there is a very large number of people arounf the
world that can not afford or can not get a high speed
internet connection, posting an attachment is considered
extremely rude and should never be done to any group that
does not have "binaries" in its name.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200703/1

punter via AccessMonster.com wrote:
I looked through your forums and didn't see this question answered. Forgive
me if it is already there and I couldn't find it.

I have a report that I want to add a new text box to. When I create a form
there is no problem choosing the different control sources of data that I
want to put into the text boxes on the report. However, once I have created
the report I can't seem to go back and make the data come through correctly
if I am adding a new text box.

Example: I want to add a text box that is pulling through data from a field
named "Duty" in a table named "Container_Vendor_Information". I put the text
box into the created form and navigated through the control source choices to
get the text box to point to where I want it to. Something goes wrong after
that. When I close the form and try to reopen it I get a pop up box that is
asking me to enter the parameter values for "Container_Vendor_Information."

I know there has to be an easy way to do this. All I'm doing is looking to
add a new text box to an exsisting form. Any thoughts would be most welcome.

I would attach the database but I guess I don't have enough posts yet to have
that option.


A text box's control source can only refer to fields in the
form's Record Source table/query.

You did not say what the form's record source is or where
the data you want to retrieve is stored, but it sounds like
you are trying to get to a different table. If so, there
should be some kind of relationship between the two tables.
If that is also the case, then the form should use a record
source query that joins the two tables or, occasionally, the
DLookup function can be used in a text box expression.

Because there is a very large number of people arounf the
world that can not afford or can not get a high speed
internet connection, posting an attachment is considered
extremely rude and should never be done to any group that
does not have "binaries" in its name.

--
Marsh
MVP [MS Access]

No apology needed, Eddie. I meant that only as a comment to
help you avoid the issue in the future.
--
Marsh
MVP [MS Access]


punter via AccessMonster.com wrote:

Thank you very much for your quick reply. I just figured out the answer when
your email popped up.

Forgive me if it was rude to comment about posting the attachments. There
was no malice behind the statement.

I am new to access and I'm sure I will other posts in the future. I look
forward to hearing your advice.


Marshall Barton wrote:
I looked through your forums and didn't see this question answered. Forgive
me if it is already there and I couldn't find it.
[quoted text clipped - 17 lines]
I would attach the database but I guess I don't have enough posts yet to have
that option.

A text box's control source can only refer to fields in the
form's Record Source table/query.

You did not say what the form's record source is or where
the data you want to retrieve is stored, but it sounds like
you are trying to get to a different table. If so, there
should be some kind of relationship between the two tables.
If that is also the case, then the form should use a record
source query that joins the two tables or, occasionally, the
DLookup function can be used in a text box expression.

Because there is a very large number of people arounf the
world that can not afford or can not get a high speed
internet connection, posting an attachment is considered
extremely rude and should never be done to any group that
does not have "binaries" in its name.