Populate Text Box

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

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!!!
 
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?
Click to expand...
Set ControlSource of your Textbox to "=cbRDIngPKID.Column(1)".

mfG
--> stefan <--
 
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)
 
Back
Top