Where Clause Keeps Getting Added to SQL

J

JamesJ

After filtering records using a combo box based on a lookup table,
and then closing the form there are times when Access 2007 adds
a Where clause to my sql statement in the Record Source of the form.
Not sure how to prevent this or what's causing it.

James
 

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

Where Clause Being Added to Select Statement 2
build the where clause... 5
Simplifying a WHERE clause 3
Can I save a sql statement generated by a search form? 1
Referring to form field in control's RowSource WHERE clause 5
help with Where clause 6
expression in SQL works in control property but not in VBA 4
Problem with complex sql statement underlying a form 1

Top