Tim,

Thanks for your questions and comments. I added the code to get an empty data set because when I first started testing, it looked like it was not clearing out the previously retrieved data when I created a new search.

The extra line to set lcPatientId = " " is just leftover code after I changed my mind about how best to handle that.

I do plan to check the query code today, having had a good night's sleep. As I was driving home on Friday, it occurred to me that the problem might be there. Funny how that works.

Thanks again.

        private void btnFindRecord_Click(object sender, EventArgs e)
        {

        ?? Why are you getting an empty data set here and below with oPatient first?

            this.oPreCertif.GetEmptyDataSet();
            string lcPatientId = " ";
            if (this.txtLocPatientId.Text == null)

     ** You shouldn't need to do this if you already set it to " " above.

                lcPatientId = " ";
            else
                lcPatientId = this.txtLocPatientId.Text;
            if (lcPatientId != " ")
            {

     ?? Did you set a break point here to verify what you are passing as this.txtLocPatientId.Text?

Alternatively, I would trace from here into your business object and step through your GetPreCertsByClientPaitentId to see what exactly is happening.

                this.oPreCertif.GetPreCertsByClientPatientId(this.txtLocPatientId.Text);
                this.oPatient.GetEmptyDataSet();
                if (oPreCertif.GetRowCount() > 0)
                {
                    this.oPatient.GetPatientByClientPatientID(this.txtLocPatientId.Text);
                    if (oPatient.GetRowCount() > 0)
                    {
                        this.txtLocLastName.Text = this.oPatient.Entity.LastName;
                        this.txtLocFirstName.Text = this.oPatient.Entity.FirstName;
                    }
                }
                else
                {
                    MessageBox.Show("Unable to locate pre-certs meeting these criteria.");
                }
            }

        }