I
inungh
I use following method to send parameters to query for optional
parameters.
1. Like [Forms]![YourFormName]![TextBox] & "*"
This one has a bug if the parameter is one then the query will
retrieve all the records prefix 1, lie 1, 10, 12, 103...etc
2. [Forms]![YourFormName]![TextBox] Or [Forms]![YourFormName]!
[TextBox] Is Null
This one works, but it creates a very long SQL statement when I have 8
parameteres optional and I got query too complex mesages.
I just wonder are there any other solution to pass optional parameters
to query.
Your information is great appreciated,
parameters.
1. Like [Forms]![YourFormName]![TextBox] & "*"
This one has a bug if the parameter is one then the query will
retrieve all the records prefix 1, lie 1, 10, 12, 103...etc
2. [Forms]![YourFormName]![TextBox] Or [Forms]![YourFormName]!
[TextBox] Is Null
This one works, but it creates a very long SQL statement when I have 8
parameteres optional and I got query too complex mesages.
I just wonder are there any other solution to pass optional parameters
to query.
Your information is great appreciated,