search feild for a combo box

[vandy]

Hi all,

I wanted to also have a search field set in the combo box which searches for
the
item no and if not found displays a msg saying item no not found. how can
this be done.

Thanks for your help in advance.

 

[Allen Browne]

See:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html

 

[Ofer Cohen]

Hi,
I'm not sure if that what you are looking for, but look at this link on
"Using a Microsoft Access Combo Box to Search for a Record"

http://www.databasedev.co.uk/combo_box_search.html

 

[vandy]

Thanks Allen this works like a charm!

See:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html