Populating A Text Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I just got some help populating a text box in a form based on a combo box
selection. Now I need to format my report and I'm faced with the same
challenge again!

The following is the thread of help for the form text box. How can I make
this work in the report, too?

THANKS!!!

John,
As long as you're capturing the txtProfileID (bound to ProfileID) in
your combo,
there's no need to "capture" the Description... just display it.
An unbound text control with a ControlSource of...
= cbRDIngPKID.Column(1)
will display the Description from the combo.
Your combo query indicates the Desc is in the second column (combo cols
are numbered
0,1,2,3...)
so that would really be Coulmn(1)
 
If you are saying you want the description in the report, just include that
field in the record source for the report.
 
I just got some help populating a text box in a form based on a combo box
selection. Now I need to format my report and I'm faced with the same
challenge again!

The following is the thread of help for the form text box. How can I make
this work in the report, too?
Click to expand...

I'd suggest basing the Report on a Query joining its current table to
the "lookup table" (the one being used as the rowsource for the
combo).

John W. Vinson[MVP]
 
You should join the two tables in the report's record source
query so the description field is available for use in the
report. If you need help with this, please post the details
of the tables and the report current record source.
 
Hi, Klatuu!

The Description field is being sourced by 3 different fields in the report:
Description
RDIngPKIDDescription
PrevRDIngPKIDDescription

I know this seems odd but trust that it's correct.

Using "Description" only works for the field named Description. The other
two fields are in reference to these fields:
RDIngPKID
PrevRDIngPKID

I need
RDIngPKIDDescription
PrevRDIngPKIDDescription

to display the descriptions of the values in
RDIngPKID
PrevRDIngPKID

I hope that makes sense! I hope it can be resolved!
 
Back
Top