show/hide combo/list box options based on login form input

[susu]

i have created a login form for 10 users from 10
different departments so each user can update his
deparments contract's details, i want each user to see
his departments contract only and restrict him of seeing
other departments contracts by hiding them in the form
drop down list. is that possible? and how can i do it.
thnx

 

[Nikos Yannacopoulos]

Definitely possible, and quite easy!
1.In your contracts table, add another field to keep the
Dept. that owns each contract
2.In the users table, add another field to associate each
user with a Dept.
3.Make your drop down list (presumably a combo box) row
source a query, in which you filter contracts owned by the
Dept the user is associated to. This means your query will
require the contracts table and the users table, linked on
the Dept. field, the criterion being current User Name
(Application.CurrentUser in the crireria line).

Nikos Y. (nyannaco at in dot gr)