combobox bookmark

[Guest]

Hi All,
I do use a combobox within my email form. This box lookes within a query for
a companyname and passes through the corresponding email address and
contactid.
I am able to use the information as I select the companyname through the
pull down menu.(after update)
strC = Me![ComboEmail].Column(2)
strB = Me![ComboEmail].Column(1)
strA = Me![ComboEmail].Column(0)
MsgBox "Combo tells strA (0) = " & strA & vbCrLf _
& "Combo tells strB (1)= " & strB & vbCrLf _
& "Combo tells strC (2)= " & strC
Me!EmailAddress.Value = strC
Me!EmailContactID.Value = strB
MsgBox "EmailAddressTO = " & Me.EmailAddress

However typing a part of the company name (the combobox) completes the name
and after pressing <enter> a msgbox tells me that all required values are
present.
but after I go to another field all values are set back to null.
Someway it does not remind the values. A next msgbox tells me that all
values are not present.

Anyone an idea how to make the combobox to remember the selected values?

Greetings,
Harry

 

[Guest]

well since no one has replied; here is a quick & dirty idea - - - rather than
using StrA,B,C, - - instead put 3 unbound textboxes onto your form

and bind them/define their control as:
= Me![ComboEmail].Column(2)
= Me![ComboEmail].Column(1)
= Me![ComboEmail].Column(0)

their values should remain available to you to re-use despite whatever field
you are in......you can of course make them not visible once you have
everything working ok....