Michael J Ross
Registered User.
- Local time
- Today, 14:30
- Joined
- Mar 2, 2006
- Messages
- 245
Hi,
This has been driving me mad for a day or two now.
I have a form which I use to feed a query which is a make table query, I'm wanting it so the user can enter as little or as much criteria as they wish. I've attached a screenshot of the form and query.
I can handle the treatment of the Vendor Id and Invoice Number if they are filled in or not, but I'm really struggling with the treatment of the other possible criteria. I have tried eg >=[Forms]![frmQuery]![text] Or >=[Forms]![frmQuery]![text] Is Null (which I found searching this forum) and it seems to work fine the first time the query is ran but after that I get a message saying the query is too complex to be evaluated and when I open the query in design view there is hundreds or rows of criteria.
Can anyone give me a pointer?
Cheers
This has been driving me mad for a day or two now.
I have a form which I use to feed a query which is a make table query, I'm wanting it so the user can enter as little or as much criteria as they wish. I've attached a screenshot of the form and query.
I can handle the treatment of the Vendor Id and Invoice Number if they are filled in or not, but I'm really struggling with the treatment of the other possible criteria. I have tried eg >=[Forms]![frmQuery]![text] Or >=[Forms]![frmQuery]![text] Is Null (which I found searching this forum) and it seems to work fine the first time the query is ran but after that I get a message saying the query is too complex to be evaluated and when I open the query in design view there is hundreds or rows of criteria.
Can anyone give me a pointer?
Cheers
Last edited:
