Populate Unbound Text Box

[JohnLute]

I have a form with a combo box named RDIngPKID:
SELECT tblProfiles.txtProfileID, tblProfiles.Description, tblProfiles.Type
FROM tblProfiles ORDER BY tblProfiles.txtProfileID, tblProfiles.Type;

The form also contains an unbound text box named RDIngPKIDDescription that
is populated according to a value selected in the combo box:
=[RDIngPKID].[Column](1)

How can I report the description?

The report queries tblProfiles.Description however this is the Control
Source for the text box named Description so I can't use it for the unbound
text box RDIngPKIDDescription. Essentially, I'm using Description twice in
the report. In the first usage it's relative to the value in txtProfileID and
in the second usage it's relative to the value in RDIngPKID.

Your help is greatly appreciated!

 

[Duane Hookom]

Why didn't you just reply in the previous thread where there are at least
two replies after your more recent?
I think we asked for the Row Source property of the combo box. Do you know
that you can include two copies of the same table in a query?

 

[JohnLute]

Hi, Duane.

I didn't reply because I may not have been very clear. Also, I was having
difficulty following the responses. I thought a new post might bring
alternative answers.

I accidentally posted this in the General Question area today and the
response was to use DLookUp which seems to be a simpler solution. However I'm
unfamiliar with DLookUP and am researching it now.

--
www.Marzetti.com

Why didn't you just reply in the previous thread where there are at least
two replies after your more recent?
I think we asked for the Row Source property of the combo box. Do you know
that you can include two copies of the same table in a query?

--
Duane Hookom
MS Access MVP

I have a form with a combo box named RDIngPKID:
SELECT tblProfiles.txtProfileID, tblProfiles.Description, tblProfiles.Type
FROM tblProfiles ORDER BY tblProfiles.txtProfileID, tblProfiles.Type;

The form also contains an unbound text box named RDIngPKIDDescription that
is populated according to a value selected in the combo box:
=[RDIngPKID].[Column](1)

How can I report the description?

The report queries tblProfiles.Description however this is the Control
Source for the text box named Description so I can't use it for the
unbound
text box RDIngPKIDDescription. Essentially, I'm using Description twice in
the report. In the first usage it's relative to the value in txtProfileID
and
in the second usage it's relative to the value in RDIngPKID.

Your help is greatly appreciated!