Filtering Records on startup

[Guest]

based on your table, you might consider adding extra field
on your table.
lets say name it selected. with yes or no type

then you can filter records that he can view based on the
selection the user made.

 

[Guest]

lets expand:

-is the user needs to be prompted everytime he opens the
database? or its a user's option to add/edit records from
particular location? (giving him choice to edit/add record
for a particular location at any given time)

 

[Guest]

The user enters a password (gives him access to all records), he would then
enter
a location (eg London)- this gives him access (read/write/edit/delete) to
only records which match this location. Navigation is via forms/subforms - do
I have to prompt the user to enter a location each time he opens a new form,
or can this be set at the start to apply globally to the database.

 

[Doug Munich]

You could have a form on which the user can choose his location, then just
hide that form (set its Visible property to No), and have all your other
forms based on a query which uses the location from the original form as a
criteria.

Doug

 

[Guest]

Thanks, that'll do it !!!!

You could have a form on which the user can choose his location, then just
hide that form (set its Visible property to No), and have all your other
forms based on a query which uses the location from the original form as a
criteria.

Doug