multiple forms

[jrb187]

I am developing a contact management program with Microsoft Access as my database. I have Form1 and Form2. Form1 and Form2 each have seperate data controls but both use the same database and recordsource. On Form1 I enter customer data then go to Form2 to enter additional data for the same customer. I do this for each customer. After I have customers in the database I have trouble keeping the data for each customer together on Form1 and Form2.
Example: Customer info on Form1 and Form2 ok for first record but when I go to search customer and the new customer comes up on Form1 the same info from the previous customer is still on Form2. How can I get the same customer info for each customer to change to Form1 and Form2 after a search is done. Also after I search a customer and go to Form2 when I return to Form1 it always go back to the first record in the database. Is there a way to get Form1 to keep the same customer info when returning from Form2 as was there when I advance to Form2.
Thanks for your help, this Forum is great.

[StarE]

Originally posted by jrb187
I have Form1 and Form2. Form1 and Form2 each have seperate data controls but both use the same database and recordsource. On Form1 I enter customer data then go to Form2 to enter additional data for the same customer. I do this for each customer. After I have customers in the database I have trouble keeping the data for each customer together on Form1 and Form2.
Example: Customer info on Form1 and Form2 ok for first record but when I go to search customer and the new customer comes up on Form1 the same info from the previous customer is still on Form2. How can I get the same customer info for each customer to change to Form1 and Form2 after a search is done. Also after I search a customer and go to Form2 when I return to Form1 it always go back to the first record in the database. Is there a way to get Form1 to keep the same customer info when returning from Form2 as was there when I advance to Form2.
Thanks for your help, this Forum is great.

IMHO
on event Mydc_Movecomplete :
form2.mygrid.bookmark = mydc.absoluteposition + 1

[paulw]

If they are the same dataset, why not use bookmarks to synchronise the datasets?

Cheers,

Paul.