Hi everyone.
I have a form with a subform.
The subform has cascading combo boxes cboNazwa1, cboNazwaEtapu, cboName3 and the Send Email subform.
In the vba code of the Send email subform I have a string;
strNazwa = Format(Forms("frmHarmonogram_02").Form("frmHarmonogramRemontu02").Controls("cboNazwaEtapu"))
The data source for the "cboNazwaEtapu" combo box is a query.
Everything works fine!
However, in the body of the e-mail, I would like to change the "ID" number to its full name.
I know I could get this by changing the combo box property - bound column, but it's not an elegant solution.
Could I please help?
I have a form with a subform.
The subform has cascading combo boxes cboNazwa1, cboNazwaEtapu, cboName3 and the Send Email subform.
In the vba code of the Send email subform I have a string;
strNazwa = Format(Forms("frmHarmonogram_02").Form("frmHarmonogramRemontu02").Controls("cboNazwaEtapu"))
The data source for the "cboNazwaEtapu" combo box is a query.
Everything works fine!
However, in the body of the e-mail, I would like to change the "ID" number to its full name.
I know I could get this by changing the combo box property - bound column, but it's not an elegant solution.
Could I please help?