query limitations with forms

  • Thread starter Thread starter Charles G via AccessMonster.com
  • Start date Start date
C

Charles G via AccessMonster.com

Is there a limit on how many forms should feed a query? I would like to
populate one query with two different forms. Am I headed down the path of
corruption or is this okay?

-Charles-
 
Is there a limit on how many forms should feed a query? I would like to
populate one query with two different forms. Am I headed down the path of
corruption or is this okay?

-Charles-
Click to expand...

I'm not sure what you're saying here. Queries do not pull data from
Forms; they pull data from Tables. A Form does not contain data and it
cannot "feed" a query anything other than a Parameter value as a
criterion. Could you explain in a bit more detail what these forms and
queries are and do?

John W. Vinson[MVP]
 
Sorry about the confusion. Can I have multiple forms with the same record
source? I have two forms sharing a single query as the record source. Is
this a sound approach?

The query consists of tblCPFTellers and tblTellerAward sharing BNumber as the
primary key.

-Charles-
 
Sorry about the confusion. Can I have multiple forms with the same record
source? I have two forms sharing a single query as the record source. Is
this a sound approach?
Click to expand...

Sure, with one caveat: if you have both forms open to the *same
record*, then the second one opened will not be able to edit any data
on the form since you'll be getting a conflict.

John W. Vinson[MVP]
 
Back
Top