By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Using the Same Form for Multiple Queries

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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, tj*****@yahoo.com (Tom Cusick) wrote:
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


Nov 12 '05 #2

P: n/a
Patrick <in**@businessformat.co.uk> wrote in
news:2v********************************@4ax.com:
Assuming the field names are identical you can simply change
the RowSource in code - search help for RowSource
Patrick
If the field names are different, you can alias them in the
queries.

Bob Q.
On 21 Oct 2003 13:18:06 -0700, tj*****@yahoo.com (Tom Cusick)
wrote:
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



Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.