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

display specific field content using combo box

P: 1
my table contains a lot of fields, so i want to create a form with a combo box and a (probably) text box that goes like this...

the combo box display the fields in the table. (this i've already done by setting row source type -> field list and row source -> my table.)

i want the text box to display the data on the field chosen.

i think this should be simple... but i can't get it to work... please help... thanks!
Jul 16 '06 #1
Share this Question
Share on Google+
3 Replies


PEB
Expert 100+
P: 1,418
PEB
Hi,

My friend I think that you omit something? The data of which record do you want to vizualize?

Without this answer I Think U can't continue!

If not your steps throu now are all right!

Have a nice luck!
Sep 6 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
In the AfterUpdate event of the Combo Box put the following code:

Expand|Select|Wrap|Line Numbers
  1. Private Sub ComboName_AfterUpdate()
  2.  
  3.     Me.textBoxName.ControlSource = Me.ComboName
  4.  
  5. End Sub
  6.  
my table contains a lot of fields, so i want to create a form with a combo box and a (probably) text box that goes like this...

the combo box display the fields in the table. (this i've already done by setting row source type -> field list and row source -> my table.)

i want the text box to display the data on the field chosen.

i think this should be simple... but i can't get it to work... please help... thanks!
Sep 6 '06 #3

PEB
Expert 100+
P: 1,418
PEB
Yes, that will work if your form is bount to your table and you have navigation records!

But I can't imagine such a Form - choosing the field name without know on wich record are you !

If there is other indications on your form on which record are you this will work If not this will be a bit strange!
Sep 6 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.