Parameter query prompts twice

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?
 
D

Douglas J. Steele

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)?
 
C

Chris K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top