1 Reply Latest reply on Apr 27, 2011 11:17 AM by pguerett

    Unique Record in Database

    Liefie2000 Level 1

      I have a form that I want to display a specific record from my database.  On the exit event of one of the fields that I'm using for search criteria, I put the following code:

       

      Database.ExecSQL("SELECT * WHERE CONF_NBR = this.rawValue AND BATCH_NBR = BatchNum.rawValue ;");

       

      After entering data in both fields, it doesn't do anything when I exit the field.  I want the form to refresh with the data from the record if it is out there on the Database. What am I missing?