How do I display query results on a continuous subform? 1

[robojeff]

I have a form called search_frm which contains three fields:

a Documentation Type field (qDocType),
a Documentation Ref field (qDocRef),
and a Documentation Desc field (qDocDesc).

I have a search button that launches a query to Search for any
text that is typed into these form fields from my table (Doc_tbl).

Here is the SQL of my query:

SELECT Doc_tbl.Type, Doc_tbl.RefNum, Doc_tbl.CurrRev, Doc_tbl.Title, Doc_tbl.Link
FROM Doc_tbl
WHERE (((Doc_tbl.Type) Like "*" & Forms!search_frm!qDocType & "*") And ((Doc_tbl.RefNum) Like "*" & Forms!search_frm!qDocNum & "*") And ((Doc_tbl.Title) Like "*" & Forms!search_frm!qDocTitle & "*"));

I would like to display the results of my query in a continuous subform on my
main form so that it updates or disappears depending on the results whenever the
query runs, but not sure how to set this up and would appreciate any suggestions
an guidance on this task.

Thanks

 

[PHV]

Create a form based on your query and then include it in your main form.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[robojeff]

Thanks PHV-

One more question...
How do I launch my query so that this subform gets updated.
I have a button but for the event, I am not which DO.CMD to use...

 

[PHV]

Use the Requery method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886