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.