I am an absolute noob at DB programming. I have a DB named "disease" and the field that holds the disease is also "disease". I don' think that matters, since it works for the most part. Headache is a column, where -1 means true and 0 is false. Here is my code:

Private Sub chkHeadache_Click()
symptoms = symptoms & " where Headache=-1"
End Sub

Private Sub cmdCompute_Click()
'Computes what diseases the user might have


Data1.RecordSource = "Select disease from disease" & symptoms
Data1.Refresh
MSFlexGrid1.Visible = True
Exit Sub
End Sub

I can't get it to have the condition work. I'm not very skilled at VB, so any help is greatly appreciated....

Thanks,
Bryan Kalciki