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

 

[bhicks11 via AccessMonster.com]

Hi Chris,

I think this is a good and easy to understand example of dependent combo
boxes for you from Blue Claw.

http://www.blueclaw-db.com/comboboxlist/access_dependent_dropdown_list.htm

Bonnie
http://www.dataplus-svc.com

 

[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?.

 

[bhicks11 via AccessMonster.com]

I might put:

me.cbox.dropdown in the ongotfocus event of each so that when you enter the
combobox if there is only one option it will populate and you can just keep
tabing through.

Not sure what you are doing with the onClick of a textbox. If you are
populating the combobox directly you have your patient name there. Why do
you also need a textbox?

Bonnie

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?.

Hi Chris,

[quoted text clipped - 24 lines]