Search results

Thank you very much HiTech Coach! That code worked perfectly....I have really been pulling my hair out over this one...I knew it had to be a simple explanation.

Thanks for your reply HiTech Coach, Your code works just as well as mine...it takes you to an existing record but no error message if the record isn't found. All it does is return the form to the first record. Any ideas? Thanks, Josh

I am trying to set a label caption to an error message when searching for a record in a form. Basically I am setting a bookmark on the form based on a text field. Here is my vb code: If DCount("[last]", "query_letters") = 0 Then lblMember.Caption = "Member not found." Else lblMember.Caption...