Populate Unbound Text Box

J

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

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?
 
J

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


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

JohnLute said:
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!
 

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