Set Combo Based on Text Field

D

DS

I want my Combo Box to be set by the value in my Text field. I thought this
would work but it doesn't. The first field in the combo box and the text
field should match.

Me.CmbLife.Value = Me.TxtLifeID

Thanks
DS
 
E

Evi

Do you really mean that you want the combo box to be set by the text field
or do you mean the opposite (and more usual scenario) - you want the text
field to be set by the combo.
If you want them always to match then you can bind them, so whatever value
you put into one, will change the other one. Is that what you want?
Where have you typed your function - in the After Update Event of the combo
or of the text box or in both?

Evi
 
J

John W. Vinson

I want my Combo Box to be set by the value in my Text field. I thought this
would work but it doesn't. The first field in the combo box and the text
field should match.

Me.CmbLife.Value = Me.TxtLifeID

Thanks
DS

Why?

What are you trying to accomplish? What are the Control Sources of the two
controls? What's the Rowsource of the combo (i.e. where does it gets its
content from)?
 
D

DS

Sorry for the delay in answering,
computer problems here.
The Set value does work now for whatever reason. I'm populating fields on a
form as well as a combo box. That is my reason.
Thanks
DS
 

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

Top