Combo Box Help

[floyd33 via AccessMonster.com]

I have a combo box that is looking up values in a table. I also have a macro
on that field on dbl click so the user can add more entries to the table as
needed. My problem is that I can't select any of the choices in the drop
down! I have enabled edits, it's not locked, etc. I am pulling my hair out
here, please help me!

 

[John W. Vinson]

I have a combo box that is looking up values in a table. I also have a macro
on that field on dbl click so the user can add more entries to the table as
needed. My problem is that I can't select any of the choices in the drop
down! I have enabled edits, it's not locked, etc. I am pulling my hair out
here, please help me!

Rather than using the dblclick event, use its Not In List event. The user can
type a value into the combo; if it's an existing value it will be selected,
and if not it will run your code (which can add what they typed to the table,
or open a data entry form, or whatever). There's sample code at

http://www.mvps.org/access/forms/frm0015.htm

or you can Google for "access notinlist".