Text Box to Pull Current Selected Information on a Report

[Tim]

Hello, I am working with Access 2003, Window XP Professional. I would like
to find an SQL procedure or VB codes where I would place either a text box or
a combo text box name PrintTextBox on a report name DeliveryTicketReport.
The PrintTextBox control would take the current DeliveryTicketReport
RecordNumber and the DeliveryTicketReport IDNumber and find a matching
IDNumber from a table name PrintMemoTable. If the DeliveryTicketReport
IDNumber and the PrintMemoTable IDNumber matches, then the text box name
PrintTextBox would pull the text from PrintMemoTable field name PrintNotes
only if a check box name ExpiredDate is not selected. I am greatly
appreciative for your assistance with this matter.--
Tim

 

[Duane Hookom]

Is it possible to join the table PrintMemoTable in your report's record
source? You could then just use a bound text box and display the value
depending on the ExpiredDate?

 

[Tim]

Duane, Thank You very much, I have join the PrintMemoTable to the report
record source, and place the control in the report footer, when I print the
report the PrintNotes appear on the report. I still need to work on your
other recommendation regarding placing a bound text box to display no text if
ExpiredDate is true. On my report designed, the newly place controls would
need to be set as invisible, would the control source of the new text box be
the ExpiredDate? I will experiment further, but if I following correctly,
some VB codes might be required for the new text box to pull the information.
Thanks again Duane, I am totally appreciative with your assistance.

 

[Duane Hookom]

I think you might use a control source like:
=IIf(ExpiredDate = False,[Field To Display],Null)