Parameter query prompts twice

  • Thread starter Thread starter Chris K
  • Start date Start date
C

Chris K

I have couple parameter queries that i use on a form

They both prompt twice for the same parameter

I have had/heard of this before on queries and simply redesigned them and it
goes away - however these work fine as stand alone queries - it's only when
i use them with my form (as recordsource) they prompt twice

What could it be?
 
Are you sure that it's the same prompt twice, or might there be a subtle
difference between them (caused by not typing the parameter consistently)?
 
I've discovered the problem - I have an instruction further down the code to
requery the form which never affected the other queries but hence re-prompt
on the 2 parameter queries

Thanks
 
Back
Top