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 .

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.

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.

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.

On Apr 12, 8:17 am, "Queezy" <que...@gmail.comwrote:

On Apr 12, 10:29 am, "access baby" <nishkr...@gmail.comwrote:
>

>
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 .