Combo box linked to Access DB
Question from a newbie:
I have a combo box on my form named cmbGender. I have an Access database with table named tblPeople and field fldGender.
I'd like my combo box to be populated with the choices "Female", "Male" and "Unknown". I can accomplish this by specifying these choices in the List property at design.
I assign DataSource to Adodc1 control.
I assign DataField to fldGender.
But I get an error stating:
Unable to bind to field or DataMember: 'fldGender'
Any thoughts on where I'm going wrong?
(Although I'd be happy just getting the word "Female", "Male", or "Unknown" into the field fldGender, ideally I'd like to have 0, 1, or 2 placed in field in an effort to save memory space.
Thanks in advance for your thoughts,
Rockman