473,385 Members | 1,655 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

display specific field content using combo box

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
3 3562
PEB
1,418 Expert 1GB
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
14,534 Expert Mod 8TB
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
1,418 Expert 1GB
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

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

Similar topics

0
by: Steve | last post by:
I have a combo box which contains a list of JobStatus's which are paired, "Description" (a string to display) and "StatID" (an Int to store). These come from my JobStatus table. I have a screen...
5
by: Elvis V. | last post by:
Good morning, I have a table with three fields, Buildings, Floors and Rooms. This is what I would like to do; in my form when I select Building1 in my drop down box for Buildings, when I go to the...
3
by: B Love | last post by:
I would like to display a drop-down list on a form conditional on the value of another field on the same form. I am not sure if this is good form or not. I am using Access97, but have access to...
2
by: Marc | last post by:
I'm back in the Access development mode and seem to have forgotten how to do 2 things that should be simple. I have a database with a table of contacts, companies and activities. The idea is that...
1
by: Jimmy Stewart | last post by:
Is there a way to set up a combo box so that when the user clicks the arrow, the list is populated with info from a specific field from a table but once they select an option, data from another...
4
by: rszebras | last post by:
I inherited a database (as a novice at Access) and need to modify it to make it more efficient, i.e., the assignment form needs to autopopulate with the client's name, address, phone number, etc.,...
11
by: Gilberto | last post by:
Hello I have a table PRODUCT NAMES with fields PRODUCTNAME and COMMODITY, another table called COMMODITY NAMES with the only field COMMODITIES (containing a list of 7 different commodities), and a...
3
by: jaymaelescent | last post by:
I have been asked by worklace to try and make a database for them, i have some experience but have encountered a problem making user specific reports. I need to make a report based on a person stored...
3
by: mckbill | last post by:
Is there a way I can direct the cursor to a specific field (variable) in a form by typing the field name while in form view? I have a form with many fields, and it would be nice if there were...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.