Retrieving a subset of records using forms

[effendi]

I have an access application which has data stored in MSDE 2005. The
database stores records from two different departments. The application
has a form which allows users from the two department to key in
information pertaining to their own department.

I need to be able to "filter" at form level so that users from each
department can only see their own records. Is this possible?

I know this can be done using a query but I had problem creating a
routine allowing users to create new records using the same form. Any
ideas?

 

[Guest]

You could use the Form's Filter and FilterOn properties; however, there must
be somthing available to the form to know what department the current user
belongs to.

 

[effendi]

You could use the Form's Filter and FilterOn properties; however, there must
be somthing available to the form to know what department the current user
belongs to.

Thanks I can't hard code it since for now we distribute two ddiferent
MS Access files so each can hv the department code

 

[Guest]

You don't have to hard code, what you need is to come up with a way to know
what department based on whos logged in.