Shell to another database--and specify form/record

[Ann in CA]

Hi,

Is there a way to pass a variable or criteria string to another database?
i.e. if a user presses the "View Linked Record" button on a form in Access
database A1, can it open up SQL server database B2 to a specific form (not
the usual opening form) and a specific record? (or Access to Access database,
the point being they are and must remain separate backends)

TIA...

 

[Brian]

I think you would want to link both backends to the single front-end. That
is, you can have links to both the Access backend and the SQL DB in the same
front-end.

Then you can just reference the records natively via bound forms. All you
have to do is to use the current value and include it in the WHERE argument
when opening the form bound to the other back-end.

Code on a form bound to Access Back-end could have code like this:

DoCmd.OpenForm "YourFormBoundToTableInSQLDB", , , "[SQLRecordID] = " &
AccessBackEndRecordID