Fill Combo Box with two box values

G

Guest

I am looking for a way to fill a combo box from two text box values on the
form. The problem is the data is not stored in a table because the user is
in data entry mode. Example, User will select the primary email from
[cmbPrimaryEmail] and the value list will come from [txtHomeEmail] and
[txtWorkEmail]. I tried to use the following
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office04062000.asp,
but it doesnt work the way i need it to. Its not updating correctly. I also
need to remove null values incase there is only one email address. Any help
would be appreciated. Thanks

Sincerely,
Raymond
 
G

Guest

I also tried to use Me!cmbPrimaryEmail.column(0, 0) = Me![txtHomeEmail], but
i get an error about procedure let
 

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

Similar Threads

Fill a Combo Box with two text boxes values 2
Combo Box case sensitivity 0
combo box selection runs query to sum values in table not gettingparameter from combo box 2
Update Combo Box 4
Filling controls based on a value in a combo box 2
Auto fill fields based on combo box selection 5
Using combo box when adding records to continuous form 1
COMBO BOX vs Uppercase 6

Top