Filtering Records on startup

G

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.
 
G

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)
 
M

MDW

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.
 
D

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
 
M

MDW

Thanks, that'll do it !!!!

Doug Munich said:
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
Click to expand...
 
Top