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!!!