Updating a lookup field

[Guest]

I have a combo box that look up a record as I type it. I want it set up so if i type a value into that combo box that does not exist in the look up list the value will be added to the list.

any tips?
Dan

 

[JulieD]

Hi Dan

check out - Add item to combo box using OnNotinList event - at
http://www.mvps.org/access/forms/frm0015.htm

this should give you what you need.

Regards
JulieD

I have a combo box that look up a record as I type it. I want it set up

so if i type a value into that combo box that does not exist in the look up
list the value will be added to the list.

 

[Guest]

MadManDan,
I am inerested in how you set up your combo box to look up a record as it
was typed.

Sincerely,
Tak