Using the Same Form for Multiple Queries

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Tom Cusick
    #1

    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
    Tags: None
    • Patrick
      #2
      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.c om (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]

        Comment

        • Bob Quintal
          #3
          Re: Using the Same Form for Multiple Queries

          Patrick <info@businessf ormat.co.uk> wrote in
          news:2v7bpvs7th 33ch3t0hg6abskt 7su9ufet7@4ax.c om:
          [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.c om (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]

            Comment

            Previous template Next
            Working...