Concerning some macros

[AmySciv]

Hello,

I created a database using macros. I am having trouble keeping the information together. For example, I have 25 clients and there data is stored on 7 different forms. Let's say that I am looking at Company 22 on page 1 and I go to page 2; it goes back to the first record. I was wondering if somebody knew how that I could correct this problem. It is a hassle trying to create new companies because you have to change the records on each form.
Please do let me know something soon.

Amy

 

[theprez]

I'm a little confused here and will probably need to look at the database. That being said, you may want to organize your companies in a combobox on some new form. Let the user select the form and then open the appropriate form filtering for the specific company you want.

This code could be on a button once the company is chosen

DoCmd.OpenForm "Someformname", , , "[CompanyName] = " & me.cmbCompanyNames

Hope this helps