Search form

[tezread]

I found a wonderful example of a search form yesterday that let you do a search by one or more criteria but I cannot find it. What I am trying to do is search for a patient and click a command button which takes me to the patient details.
I have searched the forum today but cannot find it

 

[boblarson]

Have you ever tried the Filter By Form method? It is actually pretty cool. If you select FilterByForm it clears the form and all controls are available for your input. You input it and then use ApplyFilter/Sort and it will filter it for you. You can have a single button called SEARCH which then uses

DoCmd.RunCommand acCmdFilterByForm

And then one more to apply the filter

DoCmd.RunCommand acCmdApplyFilterSort

 

[tezread]

I am trying to use form filter but I get a syntax error message (see attached)
What I really want is to have a datasheet list out all the patients and then be able to click a record on the datasheet and go into the patient details that way

 

[tezread]

sorry see attached work so far

 

[Petros]

Appologies for "dropping in" like this, but this filter by form method sounds great..reminds my of how the "larger" systems like Siebel / Oracle uses one "form" that can take the shape of a "filter"..or data input etc etc.. are there any examples of this method..would save me tonloads of forms..i think

 

[Rikki King]

Yo man,

easy ok, well what i do is just use an unbound combo box to do this so

put your combo box down then in the rowsource in the propities of the combo select the table and what you want to search for example my combo dose the same job as yours just without the button,

(SELECT tblClientDetails.[MENTA ID], tblClientDetails.[Client Surname], tblClientDetails.[Client Forename], tblClientDetails.[Client Address], tblClientDetails.[Client Address 2], tblClientDetails.Town FROM tblClientDetails ORDER BY tblClientDetails.[Client Surname], tblClientDetails.[Client Forename], tblClientDetails.[Client Address]

and that should work that dose look really confusing but its not really it just you use kinder the query builder to do so, hope it helps or if i confused you just ignor me ok take care

 

[boblarson]

sorry see attached work so far

I changed your double click event slightly (and had to create a form since you didn't have the other one in there, at least that I could find).

 

[tezread]

Thank you for the pointers guys

Muchas apprreciatos