Recordset Filters from one user affecting all users on a form??

[jazuraff]

Good Day,

Here is the environment:

Currently, I have 10 Users running a front end form that connect to back end data where they add to current records and eventually check that the record is complete.

I also have an "Apply Filter" button on the right hand side of the form that allows the user to apply filters to the records to show specific data that is not complete.

I am currently hearing that while the user is working, whether they apply filter or not, it seems as though all of a sudden, all of their completed work dissapears from their recordset hence not allowing them to go back to make changes to it if needed. I can only conclude that when a different user clicks apply filter, all users are affect some how... here are some examples of the code for the filter:

Select Case [cboFilterValues] ' Where the user selects a filter parameter from a dropdown
            Case "All Data"
                strSQL = "SELECT * " & _
                    "FROM [Data Table] " & _
                    "WHERE [Complete] = No

\

Then it does:

Me.RecordSource = strSQL

Let me know what you think. I am basically trying to find a way where only the user wanting to view the filter is affected... FYI, the other users arent actually seeing all the filters from the other user filter choice, they simply loose all their completed work from their form.

 

[Mihail]

I have not see a reason in your code to affect other FEs.