Search results

Okay... a little embarrassed. Didn't even see the asterisks and no clue how they got to be there. Keep the coffee coming. Made the corrections and it works perfectly! Thank you so much for your help.

The MgrID is an alpha-numeric code. Here's what I have... Private Sub Search_Click() On Error GoTo Err_Search_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = " MgrData" Me.MgrID.Enabled = False 'check if the MgrID was found If...

Hi Paul, The field/table names are 'MgrID'/'Managers'. When I plugged in the names and tested it, I receive the following error: Syntax error (missing operator) in query expression '*MgrID*' EK

Thank you for the quick reply! Basically I want to search my records to see if a record already exists in my master table based on the MgrID (unique identifier). If the record already exists, open form 'MgrData' and display the record. If the record does not already exist, open a msgbox...

Hello All, I am relatively new to Access and definitely new to vb, and I think I've bitten off more than I can chew. I have created a pop-up search form with the search criteria being one unbound field. When I populate the field and click search I want it to search the records and if there...