Shell to another database--and specify form/record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ann in CA - 06 Dec 2007 22:56 GMT

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...

Reply to this Message

Brian - 07 Dec 2007 05:28 GMT

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

> Hi,
>
[quoted text clipped - 5 lines]
>
> TIA...

Reply to this Message