Combo box fill in text box..BUT!

[zan]

I know how to base the combo box on a query, and in the after update enter

Me.[txtboxName]= Me.[cboName].Column(1)

BUT...

I want to bound the combo box to a control source.

How can I achieve that?

Thanks~

 

[ansentry]

Have a look at the attached sample - is this what you want to do?

 

[zan]

Exactly!

That was so simple.

I keep getting an error message, maybe I bound the wrong column.

Thanks a lot!

 

[ansentry]

That was so simple.

Just like me..........the author.

Your have 2 choices;

a) post a copy of your db and let me or someone have a look at it

or

b) Describle in detail what you have done and what the error code says. It's a bit hard to know what is wrong when you say "I keep getting an error message" what error message??

The first option is the best as we can see first hand the problem, just make a copy of your db and then remove any sensitive data and replace it with dummy data.