Using the Same Form for Multiple Queries

MS Access Version 2002 (10.4302.4291) SP-2
Windows XP Pro 2002 SP-1
-----------------------------------------------------------------
Ok my question is this. I have one form laid out the way I like it,
but I have 5 queries all are different in that they pull different
information from the databases. Is there a way to use the one form
with all the different queries instead of creating 5 duplicate forms?

Is it possible to create a search form that would allow for searching
for data to then be viewed in another form for data editing?

Tom Cusick

re: Using the Same Form for Multiple Queries

Assuming the field names are identical you can simply change the
RowSource in code - search help for RowSource
Patrick

On 21 Oct 2003 13:18:06 -0700, tjc240e@yahoo.com (Tom Cusick) wrote:
[color=blue]
>MS Access Version 2002 (10.4302.4291) SP-2
>Windows XP Pro 2002 SP-1
>-----------------------------------------------------------------
>Ok my question is this. I have one form laid out the way I like it,
>but I have 5 queries all are different in that they pull different
>information from the databases. Is there a way to use the one form
>with all the different queries instead of creating 5 duplicate forms?
>
>Is it possible to create a search form that would allow for searching
>for data to then be viewed in another form for data editing?
>
>Tom Cusick[/color]

re: Using the Same Form for Multiple Queries

Patrick <info@businessformat.co.uk> wrote in
news:2v7bpvs7th33ch3t0hg6abskt7su9ufet7@4ax.com:
[color=blue]
> Assuming the field names are identical you can simply change
> the RowSource in code - search help for RowSource
> Patrick
>[/color]
If the field names are different, you can alias them in the
queries.

Bob Q.


[color=blue]
> On 21 Oct 2003 13:18:06 -0700, tjc240e@yahoo.com (Tom Cusick)
> wrote:
>[color=green]
>>MS Access Version 2002 (10.4302.4291) SP-2
>>Windows XP Pro 2002 SP-1
>>---------------------------------------------------------------
>>-- Ok my question is this. I have one form laid out the way I
>>like it, but I have 5 queries all are different in that they
>>pull different information from the databases. Is there a way
>>to use the one form with all the different queries instead of
>>creating 5 duplicate forms?
>>
>>Is it possible to create a search form that would allow for
>>searching for data to then be viewed in another form for data
>>editing?
>>
>>Tom Cusick[/color]
>
>[/color]