order of prompt from queries for Form

  • Thread starter Thread starter babs
  • Start date Start date
B

babs

I just posted on reports and just realized I meant to say Form instead of
report - assuming that order prompts run should be same either way but just
reposted
since haven't heard back yet.

I have a Formand just looked at the design view and looked in design view
of Some of the queries that feed it- there is an invoice date prompt ( coming
from a query within it) a material date prompt from another query with in it,
a write-up date prompt again from a dif. query with in it - these all are
Part of the design view of the Form. the prompt ORDER changed- but of
course did not THINK i changed anything???

When there are mANY Paremeter queries tied to A Form- what affects the
"order of the prompts"???

thanks,
Barb
 
Babs,

Just a thought:
A much easier way for data entry is to have unbound fields on your form and
then the queries use those fields for their criteria instead of prompting for
it. Then, you can have a button or on the AfterUpdate event of the unbound
fields you can run the queries. Without knowing much about your program, I
would say in order to make the database more user friendly, do not have
parameter prompts coming from your queries.
 
Back
Top