Combo box in table but shows as Text box in Forms

G

GoToLeep

I am fairly new to access. I created the table first. Then went to create a
form. Some of the combo boxes are showing up as text boxes in the forms.
Therefore my dropdown lists is not showing up. I have checked the properties
of those that are showing correct against those that are not and they appear
to be the same. I am obviously missing something. Any and all suggestions are
welcomed.

Thanks,
Dan
 
T

tina

suggest you get rid of the combo boxes (called Lookup fields) in your
tables. they'll cause you a lot of grief in the long (and short) run. see
the link below for details

http://www.mvps.org/access/lookupfields.htm

to create a combo box control in your form, suggest you use the combo box
wizard to get an understanding of the decisions you need to make in setting
up a combo box. then look at a finished combo box control, using Help to
read up on the following properties especially: RowSourceType, RowSource,
ColumnCount, ColumnWidths, BoundColumn, LimitToList.

hth
 
Top