Problem with Filters while navigating through records on a form

J

Jetera

Hi Everyone
I have an access db 2000. It has a form that has a listbox on it - listing
connectionIDS. When you select a connectionID and click a button - a new
form opens and shows the detail for that connection.

I then added buttons to navigate through the rest of the connections.
The problem is - that each database user has their own connections and I
don't want them to see other users connections. BUT when the user clicks my
nav buttons- they see other connections that don't belong to them.

The form that shows the detail - in the query for it - I specify it to only
show the connections for the user that is logged in (a hidden field). Why is
it not listening to me?

Thanks!
 
Top