Populate Text Box

[Guest]

I'd like to poulate a text box based off of a combo box selected value.

cbRDIngPKID queries:
SELECT tblProfiles.txtProfileID, tblProfiles.Description, tblProfiles.Type
FROM tblProfiles ORDER BY tblProfiles.txtProfileID, tblProfiles.Type;

I want to populate the text box RDIngPKIDDescription with the Description
above.

How can I do this?

Thanks!!!

 

[Stefan Hoffmann]

hi John,

SELECT tblProfiles.txtProfileID, tblProfiles.Description, tblProfiles.Type
FROM tblProfiles ORDER BY tblProfiles.txtProfileID, tblProfiles.Type;
I want to populate the text box RDIngPKIDDescription with the Description
above.
How can I do this?

Set ControlSource of your Textbox to "=cbRDIngPKID.Column(1)".

mfG
--> stefan <--

 

[Al Campagna]

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)

 

[Guest]

Thanks, Stefan! That was simple enough!!!