I have added some combo boxes to my form. In the row source line, I added the options I would like to use. However, after I save the form, and try to input data; these options are not in the combo box. What am I doing wrong?
I have added some combo boxes to my form. In the row source line, I added the options I would like to use. However, after I save the form, and try to input data; these options are not in the combo box. What am I doing wrong?
Check the columns property, put the table ID as 0' length, then whatever length for the other fields in the row source
I usually have ID and Description fields
so cats table
ID CatName
1 Garfield
2 Felix
3 Mittens
so column one in your columns should be 0 (because you want to have id field, just not view it)
then say 6 for the next column.
Column Widths and Column Count properties for the combobox
Thanks so much for your help. I actually found that when I changed the Row Source Type to Value List, it worked. My data base was originated in an earlier version and the things that worked in that version are different then what works now...