Record not found code

[rjinxed]

I have a drop down box that I am using to search the database, if the record
is not found it goes to the first record in the database. I would like to
have a msgBox popup and state that the record was not found. Any help would
be greatly apprectiated, thanks in advance.

 

[Allen Browne]

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

The code shown there pops up a MsgBox if not found.

 

[rjinxed]

The link to your sample really helped clear it up, thanks!