Solved Open another Database and find customer

[Number11]

so, i am using this code to open another database

accapp.OpenCurrentDatabase ("pathhere")
accapp.Visible = True

both databases have a customer account number field, how to I get the open database to select the same customer from the original database?>

 

[theDBguy]

You can save the number into a variable, so you can access it anytime.

 

[namliam]

why physicaly access the database? Use linked tables to access the customer table directly without actually "touching" the database.

 

[HiTechCoach]

I agree with namliam.

If at all possible, use linked tables to read the data you need. If you have access to the other front end (/mdb/.accdb) or non-split database, then you could import the object (forms, query, etc) needed to display the required data.

Linked tables would allow the elegant solution of displaying data from the other database on your existing form in a subform control Would that make the users really happy and more productive?