Searchform to select data into a 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

 

[Arvin Meyer MVP]

Have you seen the Search Wizard at The Access Web:

http://www.mvps.org/access/modules/mdl0056.htm

 

[Chris]

Hi Arvin

No I haven't found that one, thanks for the tip

Searching for records isn't really the problem.
The problem is how to insert the found record into my form from the
searchform.

 

[Arvin Meyer MVP]

If tyou leave the search form on the screen, you can use a button on your
form to read the records onto your form like:

Sub myBtn_Click()
Me.txt1 = Forms!SearchForm!SomeTextbox
Me.txt2 = Forms!SearchForm!SomeOtherTextbox
End Sub