Search Form

[RobUCSD]

I need to build a search form that can look a patient up by any one of the
following 4 fields; fldMRN, fldLastName, fldFirstName, fldDOB. I would like
the results to be displayed in a list box where I can dblclk on the correct
pt and then load that pt into my frmPtDemographics. If the pt is not found,
then I need to load my frmPtDemographicsNewPatient and add that pt and then
load it into the frmPtDemographics (main form).

I know this is alot to ask but any help would be much appreciated.

Thanks,

RobUCSD

 

[Allen Browne]

Couple of ways to handle this.

This one has a combo where you choose which field you want to match, and
text box where you type the part of the name. It then filters your form
between keystrokes:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html

This one has different controls where you can enter the values to match
against a particular field, and it matches the combination of values when
you click the button:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

The first one is copy'n'paste, and set one property.
The second one serves as an example of how you can program this.