Access Forms_

[Guest]

I have created a form based on two separate tables. One table holds names
the other table holds data. I need multple to use the database and to have
the name selections save for each auditor separately. Can anyone help?

 

[John W. Vinson]

I have created a form based on two separate tables. One table holds names
the other table holds data. I need multple to use the database and to have
the name selections save for each auditor separately. Can anyone help?

I have no idea what you mean by "multple to use the database" nor what an
"auditor" might be, nor how these tables are related.

I would assume that you will need a form with a subform - and possibly an
additional field or table indicating who the auditor is, if each auditor is
responsible for a different subset of the names records.

Care to post a bit more information about the nature of the data and the
structure of your tables?

John W. Vinson [MVP]

 

[Guest]

Okay, I will try to explain more. I have one table of just names, the other
table has other data like loan numbers and related information. I used both
tables to create a form. What I meant to say was I need "multiple users" to
be able to access the form at the same time, by selecting their own names as
well as allowing others to see that they are in a specific loan number.

Please can you help again.

Thank you

 

[Guest]

Oh I forgot. The names are in a drop down box on my form. Thanks

 

[John W. Vinson]

Okay, I will try to explain more. I have one table of just names, the other
table has other data like loan numbers and related information. I used both
tables to create a form. What I meant to say was I need "multiple users" to
be able to access the form at the same time, by selecting their own names as
well as allowing others to see that they are in a specific loan number.

Please can you help again.

Thank you

I'll really need more information to be able to help! Remember that you can
see your computer; we cannot.

What is the Primary Key of each table?
What is the Recordsource of the form? Is it a query joining the two tables, or
do you have a form with a subform (preferable)?
Do you have a "split" database, with each user getting their own copy of the
frontend (a database with the forms, queries, reports etc.) and sharing a
backend containing the tables? If not... you really should.


John W. Vinson [MVP]