options in form

J

jomblo

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
 
J

John Vinson

Hi all

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

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?
Click to expand...

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
 
J

jomblo

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

jomblo

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

John Vinson

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

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
 
Top