J
JD McLeod
My primary table contains records for different departments (loans, deposits,
etc.). I have a form set up for data entry which has a filter applied at
start up to only show the records for a specific department (loans).
Therefore in this example, I have two forms that are identical, except one
has a filter for loans and one has a filter for deposits. The user can only
add/modify records to the table by using the forms. I want to apply a rule
that prevents a form from being open by more than one person at a time. The
file is stored on a shared directory and we have about 5 or 6 users. Last
year, I created a query for each department and had the individual forms run
off the query, but this year, I decided to use a filter and not have those
extra queries. Thanks.
etc.). I have a form set up for data entry which has a filter applied at
start up to only show the records for a specific department (loans).
Therefore in this example, I have two forms that are identical, except one
has a filter for loans and one has a filter for deposits. The user can only
add/modify records to the table by using the forms. I want to apply a rule
that prevents a form from being open by more than one person at a time. The
file is stored on a shared directory and we have about 5 or 6 users. Last
year, I created a query for each department and had the individual forms run
off the query, but this year, I decided to use a filter and not have those
extra queries. Thanks.