Before I will ask my question, I would like to apologize to the administrator for what mistake I had done on giving negative comment, I am very sorry for violating the rules due to mistake answer on the comment. But anyway I will proceed to my question regarding this topic. What is the best way of using the search record in access? I am using the combo box control to search certain code but my problem is, if the code which I am searching is not on the table when I press enter it will give me another code. What I want is I want the message appear if the code is not on the record. Thanks in advance.

If you are using a combobox for a search then use the NotInList event to customize what will happen if the value you enter is not found. However, if you ARE using a combo to search, then if you select a value fromt the combo, then it should be there.

P.S. The guidelines are using the Comments feature are guidelines, not rules, but we prefer they be followed. But I think you missed some of my point that, if a solution doesn't work for you, then you need to explain how it didn't work and ask a follow-up question.

Thanks.