show query results in a subform

spiderq

New member
Local time
Today, 15:37
Joined
Mar 27, 2004
Messages
6
I have a problem (hopefully simple) with a query which is supposed to show its results in a subform.
The query searches a member table to display all names based on a wildcard search using a textbox as its parameter source(searches the surname).The query itself works BUT I want to display this as a subform.
I have used the wizard to create my subform, based on this query, using the display all records based on my surname search. The problem is when I run the query the results are just shown as a standard query result datasheet- not on my subform. Have I missed something here- anyone any ideas? :confused:
 
You are starting at the wrong end. If you open your main form this will load the subform. Loading the subform will cause the query to run.

It sounds like you are running the query and expecting the subform to load and thus the main form.

The display of the results of your query is not limited to the form or subform you have based on it. You might use the data in a query as the basis for more than one form or report, plus you can see it in datasheet view.

If this doesn't fit your situation, let me know and I'll have another run at it.
 

Users who are viewing this thread

Back
Top Bottom