ODBC/sorting/parm query issue

S

Stefanie

Hi,

I have a form that is linked to a DB2 table via ODBC/DB2 Connect. The form
is set up to use parameter queries to limit the amount of data returned.
Sometimes the user will sort or filter the returned data and Access hangs on
to the sort/filter so when the next user goes to use the form, the data is
returned using the sort/filter set up by the previous user.

I've tried coding

Me.FilterOn = False
Me.Filter = " "
Me.OrderByOn = False
Me.OrderBy = " "

which works, but causes the parameter queries to pop up a second time. Does
anyone know of a way to prevent the parameter query windows from popping up a
second time?

Thanks,

Stefanie
 

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

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Access Query to import from Sharepoint 0
Sort by 2 fields 1
Using a Label to Sort 6
Current event firing on form closure ? 1
Order by on form open 4
Remove sort and filters programmatically on form 2
filtering a form based on a filter on an open form 1

Top