Query design for search button

[ashu.doc]

hi everyone
I am trying to make a query for a search button which should bring a record as its original form not in its table form. at the moment I am using this query to get the record as table form:

[Forms]![F_Search]![combo1]
where combo1 is the search criteria box. This gives me the result in table form, but I want the result to show that form which I have used to enter the data for that particular record, so that if I want to edit the form, I can edit.

many thanks


Ash

[orange]

Please explain this

a record as its original form not in its table form

.

Perhaps an example would help.

[June7]

Not sure what you mean by "bring a record as its original form not in its table form" nor "result in table form, but I want the result to show that form which I have used to enter the data".

Do you need to apply filter to a form RecordSource?

You did not post a query statement. I NEVER use dynamic parameterized queries. I prefer VBA to search and filter http://www.allenbrowne.com/ser-62.html

[ashu.doc]

So this is the form I use for entering the data. And ofcourse data is collected as table.
Then this is the search form:


So if I search a patient, is it possible to get the record of patient as the form above? Currently I am using that simple query which I have mentioned above which just show me the record of that patient in a table form.

Many thanks
Ash

[June7]

The search controls can be in the Header section of the data entry form. Did you try the method from the link?

[ashu.doc]

@June7 but will this method not bring the results in table? I need to pull out the result in the Form view.

[June7]

The method demonstrated in link applies filter criteria to the form to display desired record(s).

[ashu.doc]

Not sure how can I apply this to what I need.

[June7]

I don't understand how you could not apply it.