473,322 Members | 1,409 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,322 software developers and data experts.

value in list box or combo box

i would like to use combobox or list box in a form for data entry do i
have to have a table with value in it and the combobox or list box
should look in to that table or i type in the values. 'cause when i
create a form with text box and change it to combobox the box is empty
there are no records in it .

Apr 12 '07 #1
4 7467
On Apr 12, 10:29 am, "access baby" <nishkr...@gmail.comwrote:
i would like to use combobox or list box in a form for data entry do i
have to have a table with value in it and the combobox or list box
should look in to that table or i type in the values. 'cause when i
create a form with text box and change it to combobox the box is empty
there are no records in it .

It's best to create the combobox seperately, as when you create it, a
wizard will appear giving you options. When you change a textbox to a
combobox these options that are usually inputted in the wizard, are
unknown and thus it doesn't work. Try creating a combobox from the
toolbox and read all the options carefully, and it will also ask you
what record source to pull from.

Apr 12 '07 #2
On Apr 12, 10:29 am, "access baby" <nishkr...@gmail.comwrote:
i would like to use combobox or list box in a form for data entry do i
have to have a table with value in it and the combobox or list box
should look in to that table or i type in the values. 'cause when i
create a form with text box and change it to combobox the box is empty
there are no records in it .
If you are using this combobox for data entry, then try this:

-Create a combobox from scratch in toolbox (changing textboxes to
combo's isn't the best idea).
-Once you drag the combobox to the size you want, a wizard will
appear.
-Choose the 1st option "I want the combo box to look up the values in
a table or query."
-Choose the table your field is in, then choose your field on the
following screen.
-Choose sort order, if you want to sort by a different field choose
it, but most likely will be choosing the field in the combo box.
-Last screen select the 2nd option "Store that value in this field" ,
and select your field.

Apr 12 '07 #3
On Apr 12, 10:29 am, "access baby" <nishkr...@gmail.comwrote:
i would like to use combobox or list box in a form for data entry do i
have to have a table with value in it and the combobox or list box
should look in to that table or i type in the values. 'cause when i
create a form with text box and change it to combobox the box is empty
there are no records in it .
If you are using this combobox for data entry, then try this:

-Create a combobox from scratch in toolbox (changing textboxes to
combo's isn't the best idea).
-Once you drag the combobox to the size you want, a wizard will
appear.
-Choose the 1st option "I want the combo box to look up the values in
a table or query."
-Choose the table your field is in, then choose your field on the
following screen.
-Choose sort order, if you want to sort by a different field choose
it, but most likely will be choosing the field in the combo box.
-Last screen select the 2nd option "Store that value in this field" ,
and select your field.

Apr 12 '07 #4
On Apr 12, 8:17 am, "Queezy" <que...@gmail.comwrote:
On Apr 12, 10:29 am, "access baby" <nishkr...@gmail.comwrote:
i would like to use combobox or list box in a form for data entry do i
have to have a table with value in it and the combobox or list box
should look in to that table or i type in the values. 'cause when i
create a form with text box and change it to combobox the box is empty
there are no records in it .

If you are using this combobox for data entry, then try this:

-Create a combobox from scratch in toolbox (changing textboxes to
combo's isn't the best idea).
-Once you drag the combobox to the size you want, a wizard will
appear.
-Choose the 1st option "I want the combo box to look up the values in
a table or query."
-Choose the table your field is in, then choose your field on the
following screen.
-Choose sort order, if you want to sort by a different field choose
it, but most likely will be choosing the field in the combo box.
-Last screen select the 2nd option "Store that value in this field" ,
and select your field.
Thanks so much for your help .

Apr 12 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

16
by: cwizard | last post by:
I'm calling on a function from within this form, and there are values set but every time it gets called I get slammed with a run time error... document.frmKitAmount.txtTotalKitValue is null or not...
2
by: Ted | last post by:
How do I allow a user to enter a new value into a combo box for web-based (.Net) application? The orgiginal platform was a networked solution. The user could enter a new value if they didn't...
2
by: Dave N | last post by:
I have a combo box that displays the names of all the users in my "Users" table. I set the RowSource to a Query from the "User" and "Project" tables. I can select any name from the list and that...
2
by: Terry Bickle | last post by:
Please forgive me for using the wrong term here or there. I'm an old Excel 4 macro guy who didn't convert to VB and I'm tinkering with an Access 2000 DB. I'm sure there is a simple Access 101...
20
by: MLH | last post by:
120 MyString = "How many copies of each letter do you need?" 150 MyVariant = InputBox(MyString, "How Many?", "3") If MyVariant = "2" Then MsgBox "MyVariant equals the string '2'" If...
7
by: sara | last post by:
I have a form where the user selects an item from a list box, and then works on that item. The user chooses an AD, then opens a form to assign departments to the ad. The top of the Depts form has...
1
by: Matthew Wells | last post by:
This one has bugged me for years. I have a combo box after-update event that sets a one column list box to a string value. (The lsit box is a list of tables). I check the value of the list box...
9
by: Ecohouse | last post by:
I have a main form with two subforms. The first subform has the child link to the main form identity key. subform1 - Master Field: SK Child Field: TrainingMasterSK The second subform has a...
2
by: mvlt | last post by:
I am using Access 2003 and working on a query by form. I have a form with two unbound combo boxes. The form searches our contact list for people in a certain renewal cycle. It then gives the...
2
by: ringer | last post by:
I use a combo box to select a value from a list but I don't want what is selected to be written to the record. I need each selection of the combo box to correspond to another value that should be...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.