using query results to search by

Question posted by: kevcar40 (Guest) on July 13th, 2006 08:25 AM

hi
i have a query which returns the top 5 Areas of concern
i.e Area(field name)
Area 1
Area 2
Area 3
Area 4
Area 5
the results are displayed on a continuous form
i am now trying to use this result to trigger another query
i need a way of running through the results then finding the faults
with that area
i.e
if result = Area 1 then open query faultsarea1
if result = Area 2 then open query faultsarea2
if result = Area 3 then open query faultsarea3
can anyone help please

thanks kevin

Quote | Subscribe

salad July 13th, 2006 05:15 PM

Guest - n/a Posts

#2: Re: using query results to search by

kevcar40 wrote:

Quote:

Originally Posted by

Could you define your problem a bit further. You have a recordsource
for the form that displays Area1..5 which has the column name Result if
I understand you correctly.

Now when do you want to run the queries? You could open up the property
sheet for Results, click the Events tab, and in the Dbl-Click event call
your routine to open up the query. Ex:
Dim strQryName As String
strQryName = "faultarea" & result
DOcmd.OpenQuery strQryName

kevcar40 July 14th, 2006 10:25 AM

Guest - n/a Posts

#3: Re: using query results to search by

salad wrote:

Quote:

Originally Posted by

kevcar40 wrote:
>

Quote:

Originally Posted by

Could you define your problem a bit further. You have a recordsource
for the form that displays Area1..5 which has the column name Result if
I understand you correctly.
>
Now when do you want to run the queries? You could open up the property
sheet for Results, click the Events tab, and in the Dbl-Click event call
your routine to open up the query. Ex:
Dim strQryName As String
strQryName = "faultarea" & result
DOcmd.OpenQuery strQryName

thank you for your reply
i will try this code and see how i get on thanks again

using query results to search by

What is Bytes?

Popular Articles

Top Community Contributors