By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,672 Members | 1,628 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,672 IT Pros & Developers. It's quick & easy.

Is this a stupid question?

P: n/a
Hi, Is this a stupid question?

Senario: Two tables linked together with an ID number.

Question: When using a combo box, which refences another table by
indexed autonumber, is there a way to copy the returned text value to
a text field. I have many combo boxes and after the value changes I
would like a normal text field to show the returned text value,
regardless of which combo box was changed.

A little like the "paste as values" option in excel if you know what I
mean.

Thanks
Matt
Jun 27 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"Lynx101" <ma**********@gmail.comschreef in bericht news:e2**********************************@2g2000hs n.googlegroups.com...
Hi, Is this a stupid question?

Senario: Two tables linked together with an ID number.

Question: When using a combo box, which refences another table by
indexed autonumber, is there a way to copy the returned text value to
a text field. I have many combo boxes and after the value changes I
would like a normal text field to show the returned text value,
regardless of which combo box was changed.

A little like the "paste as values" option in excel if you know what I
mean.

Thanks
Matt
Not a stupid question, but a 'unclear' question (to me)
So I am not sure I understand what you are asking...

You are having "many combo boxes" ...
When "the value" changes (what value ??) ...
you want the "returned text value" (you mean the value of the choosen item in the combo ??) ...
to show in a normal text field somewhere ???

IIUC then you need something like this code in the afterupdate event of the combo's
Me!NormalTexTField=Me!ThisComboName.Column(0)

Arno R
Jun 27 '08 #2

P: n/a
yes sorry about that.

You have hit this one on the head. I've used your method and it works
perfectly. Really appreciate (1) decoding my initial request (2)
finding a perfect solution.

Many thanks
Matt
Jun 27 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.