search form

[Chris]

Hello,

I have made a database for introducing prescriptions.
In my form I have to insert data for Date, Patients, Doctors, Pharmacists en
Drugs (in subform).
I have been using a cbobox with multicolumns to find Patients. It works
fine, but I only have one field to search in. As the database will grow, I
will be difficult to find Patients with one cboBox.

I am looking for a way to make a search form for the patients on Name,
FirstName, Birthday and Gender and then Select the chosen Patient into my
form of prescriptions.

I have found the Searchform from Alan Brown, but I have no clue on how to
implement this in my form.

Thanks for any idea

 

[Chris]

Thanks Bonnie for the tip.

I have made a search form with cboPatientNaam, cboPatientVoornaam en
cboPatientGeboortedatum. (depending on a query named QPatientSearch)
I guess I have to use the onClick( or dblclick ) event on a textbox
"Patient" to have it open so I can do my search for the Patient.
Untill here I can easely follow.

The next thing I don't know where to begin:
I should make a cmdbutton on my searchform so I can select the PatientID and
put it into my frmPrescriptions in the textbox "Patient"

Another question: Is there a way that the second cbobox updates directly
when there is only one choice left in the Searchform?.