Searchform to select data into a form

  • Thread starter Thread starter Chris
  • Start date Start date
C

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
 
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.
 
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
 
Back
Top