options in form

[Guest]

Hi all

I just lean access about 3 days ago. I have one issue to clarify here:

I have this one table, and from that table i made few queries i.e: query 1,
query 2, query 3. And some fields on those queries are different. then i
created autoform for each query and also main form for user to start from. In
the mainform i create three options based on those form queries(query1 =
1,query2 =2, query3 = 3) and "review" button. in that button i create macro
such that it will open form based on user choise. Now here is the question,
is the program process all calculations in every queries before it comes
displaying form OR it only calculate synchronized query based on user choise?

Please help

TIA

 

[John Vinson]

Hi all

I just lean access about 3 days ago. I have one issue to clarify here:

I have this one table, and from that table i made few queries i.e: query 1,
query 2, query 3. And some fields on those queries are different. then i
created autoform for each query and also main form for user to start from. In
the mainform i create three options based on those form queries(query1 =
1,query2 =2, query3 = 3) and "review" button. in that button i create macro
such that it will open form based on user choise. Now here is the question,
is the program process all calculations in every queries before it comes
displaying form OR it only calculate synchronized query based on user choise?

The calculations in the Query are executed row by row as you navigate
through the records on the Form.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

So in that sense will calculation in query 2 be calculated if i choose other
option (i.e:query 1) ?

 

[Guest]

So in that sense will callculation in query 2 calculated if i choose other
option(i.e: query2) ?

 

[John Vinson]

So in that sense will calculation in query 2 be calculated if i choose other
option (i.e:query 1) ?

I don't understand your question, or what you're trying to get at!

No. If you open Query1, Query2 does NOTHING - it just sits there
waiting to be executed, unless Query1 uses Query2 as part of its
structure.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps