I have two seperate databases with similar fields one has contact information the other is an order administrator. Is there a way to hit a button in one database that would then open another database, then open a specific form, then populate certain fields with the information from the first database. On top of all this the databases have logon screens. Any help with this would be greatly appreciated.

Help! I'm drowning in a sea of my ineptitude!!!!

Hi big,

Not real sure what we're talking about here.

Why not just link to the tables in the other database?

Wayne

Thanks for responding, I'll try to be more clear. I have it now that in DB #1 once a button is clicked the necessary info gets appended into DB #2.
What I want to do is after the info is append, DB #2 is then opened and a form in DB #2 is opened with particular info filled (strLinkCriteria). This is my dilemma.