Query auto populates criteria rows after running...

  • Thread starter Mickey via AccessMonster.com
  • Start date
M

Mickey via AccessMonster.com

hi there,

I wonder if anybody could give me a hand and explain what is happening with
one of my queries. The thing is, I have a form with 4 combos wich select
criteria for a query. Then I run the query with a macro attached to a button.

The problem is, after running the query, if I go to design view, I conclude
that I have 14 new (random) rows of criteria of the type Forms![FormName]!
[cboName]... Strangely, the query seems to continue to work fine.

This happens even if I don't run the query via the macro button. However, if
I delete the criteria types "Forms![FormName]![cboName]" from the 1st
criteria row, the "auto-population" of more criteria rows does not happen
again...

Is this normal? Does anybody have any idea of what is going on?

Thank you in advance for your replies.

Mickey
 

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

Similar Threads

'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Query with Multiple Criteria 4
Select query problems Access 2003 2
Run query in another database 5
Combobox for criteria help 5
Using expressions for Query criteria 2
QBF & Query Malfunction 0
Query with more than 8 'OR' criteria? 2

Top