Can I use 1 form for 37 users?

[Utracman]

I'm new to programming.

I have an Access database that is used in a multi-user enviroment that I set up querries and forms for every user.

Example - Database that stores account info

frmAM - Has several controls that displays - Account ID, Business Name, Address, Phone, Contact, Base ID and so on...

I had to (due to my ignorance)make copies of frmAM rename them for every Rep (37)and make a seperate querry for each. Well what a nightmare and time consuming mess this is. When I make changes to the form I have to repeat the entire copy/rename code over and over.

There must be a better way.

Thanks for your help!!!

[Ishamel]

How about placing a combo box at the top of your form and populating it with the 37 users?

Then when a user is selected from the combo box, you can populate the fields on the form accordingly.

Hope this helps.

[Utracman]

Ishamel

Thanks

I have 5 sales teams and I want to keep the teams in their own accounts.

Now I have a select team form that opens a team form with controls that opens the account form with the related records. How do I use a combo box on the team form to open records that relate to the rep in Account form?

Thanks again

Utracman