Opening another database, passing a variable

[Guest]

Okay, so no one was able to help you with my prior idea of asking Access to
open a report in an different database.

http://www.microsoft.com/office/com...06a3&mid=e82a4613-cdf9-4f7b-b8ea-e2a6288206a3

I was able to get the database open, but when giving commands to open a
report, it wants to look in the database where we started. Fair enough.

My workaround will now be to open the database, have a form that opens on
startup which will automatically forward to the report in this other database.

So.... if I'm in a general "Customer" form on Database #1, looking at
"[CustomerID]=15", how do I pass that [CustomerID] variable to Database#2
when I ask Database#1 to open it?

 

[Guest]

From one DB you can create a reference to another DB, the main DB will
recognise all the functions in the link DB.

In the link Db you can create a function that get a parameter and open a
report using this parameter.

 

[Guest]

Sounds good, but I'm having a problem figuring out how I would code that,
where I would code it, or how I would call that code. All references to
references in Vb or Access help are very circular, referring to itself as
part of the definitions.

Let's say I have "database1.mdb", and on "frmForm1" I have a "CustomerID"
that I want to pass.

On "database2.mdb" I have "rptReport2" that I want to call up, using the
"CustomerID" from "database1" as the variable I want to filter on. Let's say
my query field that it corresponds to is "Customer2ID"

How do I set up the references that allow me to pass the "CustomerID" on
"database1", "form1" to the "Customer2ID" field on "database2", "report2"?

From one DB you can create a reference to another DB, the main DB will
recognise all the functions in the link DB.

In the link Db you can create a function that get a parameter and open a
report using this parameter.

Okay, so no one was able to help you with my prior idea of asking Access to
open a report in an different database.

http://www.microsoft.com/office/com...06a3&mid=e82a4613-cdf9-4f7b-b8ea-e2a6288206a3

I was able to get the database open, but when giving commands to open a
report, it wants to look in the database where we started. Fair enough.

My workaround will now be to open the database, have a form that opens on
startup which will automatically forward to the report in this other database.

So.... if I'm in a general "Customer" form on Database #1, looking at
"[CustomerID]=15", how do I pass that [CustomerID] variable to Database#2
when I ask Database#1 to open it?

 

[Guest]

Also, is this creating a reference to another DB something that can be done

From one DB you can create a reference to another DB, the main DB will
recognise all the functions in the link DB.

In the link Db you can create a function that get a parameter and open a
report using this parameter.

Okay, so no one was able to help you with my prior idea of asking Access to
open a report in an different database.

http://www.microsoft.com/office/com...06a3&mid=e82a4613-cdf9-4f7b-b8ea-e2a6288206a3

I was able to get the database open, but when giving commands to open a
report, it wants to look in the database where we started. Fair enough.

My workaround will now be to open the database, have a form that opens on
startup which will automatically forward to the report in this other database.

So.... if I'm in a general "Customer" form on Database #1, looking at
"[CustomerID]=15", how do I pass that [CustomerID] variable to Database#2
when I ask Database#1 to open it?

 

[Guest]

No problem there
1. In MDB1 You have a form with a text box called employeeNum containing
employee Num, and a button that run a function OpenEmployeeReport (
me.employeeNum)

2. in MDB2 create a function
Function OpenEmployeeReport ( employeeNum as long)
docmd.openreport "ReportName",,, "[Employeenum] = " & employeeNum
End Function

3. Open The refernce in MDB1 (open code any where, go to tools, reference)
browse and select MDB2.

4. Now run the form and click the button, it should run the function you
created in MDB2.

note:
if you make changes to MDB2 and MDB1 is open, you have to close MDB1 so it
will recognise the changes you made.

Also, is this creating a reference to another DB something that can be done

From one DB you can create a reference to another DB, the main DB will
recognise all the functions in the link DB.

In the link Db you can create a function that get a parameter and open a
report using this parameter.

Okay, so no one was able to help you with my prior idea of asking Access to
open a report in an different database.

http://www.microsoft.com/office/com...06a3&mid=e82a4613-cdf9-4f7b-b8ea-e2a6288206a3

I was able to get the database open, but when giving commands to open a
report, it wants to look in the database where we started. Fair enough.

My workaround will now be to open the database, have a form that opens on
startup which will automatically forward to the report in this other database.

So.... if I'm in a general "Customer" form on Database #1, looking at
"[CustomerID]=15", how do I pass that [CustomerID] variable to Database#2
when I ask Database#1 to open it?

 

[Guest]

Write the call for the function like that

OpenReportCard Me.DistrictID

other wise it search for a sub

Sure....

In DB1 -

Private Sub cmdprevrptDistrictProfileRedo_Click()

OpenReportCard (Me.DistrictID)

End Sub
-------------------------------------
IN DB2 -

Public Function OpenReportCard(DistrictID As Long)

DoCmd.OpenReport "rptDistrictProfile2005Ind", , , "[DistrictID]= " &
DistrictID

End Function
-------------------------------------

can you post the code you created in both mdb.

When I try to run it, I get a "sub or function not defined" error.

Any ideas? When I program the button, it creates a "sub" for the "on click"
event, and my OpenEmployeeReport is the sole command for the sub. I'm
assuming that's how you program that button....

:

No problem there
1. In MDB1 You have a form with a text box called employeeNum containing
employee Num, and a button that run a function OpenEmployeeReport (
me.employeeNum)

2. in MDB2 create a function
Function OpenEmployeeReport ( employeeNum as long)
docmd.openreport "ReportName",,, "[Employeenum] = " & employeeNum
End Function

3. Open The refernce in MDB1 (open code any where, go to tools, reference)
browse and select MDB2.

4. Now run the form and click the button, it should run the function you
created in MDB2.

note:
if you make changes to MDB2 and MDB1 is open, you have to close MDB1 so it
will recognise the changes you made.

:

Also, is this creating a reference to another DB something that can be done
on Access 2000?

:

From one DB you can create a reference to another DB, the main DB will
recognise all the functions in the link DB.

In the link Db you can create a function that get a parameter and open a
report using this parameter.



:

Okay, so no one was able to help you with my prior idea of asking Access to
open a report in an different database.

http://www.microsoft.com/office/com...06a3&mid=e82a4613-cdf9-4f7b-b8ea-e2a6288206a3

I was able to get the database open, but when giving commands to open a
report, it wants to look in the database where we started. Fair enough.

My workaround will now be to open the database, have a form that opens on
startup which will automatically forward to the report in this other database.

So.... if I'm in a general "Customer" form on Database #1, looking at
"[CustomerID]=15", how do I pass that [CustomerID] variable to Database#2
when I ask Database#1 to open it?

 

[Guest]

can you post the code you created in both mdb.

When I try to run it, I get a "sub or function not defined" error.

Any ideas? When I program the button, it creates a "sub" for the "on click"
event, and my OpenEmployeeReport is the sole command for the sub. I'm
assuming that's how you program that button....

No problem there
1. In MDB1 You have a form with a text box called employeeNum containing
employee Num, and a button that run a function OpenEmployeeReport (
me.employeeNum)

2. in MDB2 create a function
Function OpenEmployeeReport ( employeeNum as long)
docmd.openreport "ReportName",,, "[Employeenum] = " & employeeNum
End Function

3. Open The refernce in MDB1 (open code any where, go to tools, reference)
browse and select MDB2.

4. Now run the form and click the button, it should run the function you
created in MDB2.

note:
if you make changes to MDB2 and MDB1 is open, you have to close MDB1 so it
will recognise the changes you made.

Also, is this creating a reference to another DB something that can be done
on Access 2000?

:

From one DB you can create a reference to another DB, the main DB will
recognise all the functions in the link DB.

In the link Db you can create a function that get a parameter and open a
report using this parameter.



:

Okay, so no one was able to help you with my prior idea of asking Access to
open a report in an different database.

http://www.microsoft.com/office/com...06a3&mid=e82a4613-cdf9-4f7b-b8ea-e2a6288206a3

I was able to get the database open, but when giving commands to open a
report, it wants to look in the database where we started. Fair enough.

My workaround will now be to open the database, have a form that opens on
startup which will automatically forward to the report in this other database.

So.... if I'm in a general "Customer" form on Database #1, looking at
"[CustomerID]=15", how do I pass that [CustomerID] variable to Database#2
when I ask Database#1 to open it?

 

[Guest]

When I try to run it, I get a "sub or function not defined" error.

Any ideas? When I program the button, it creates a "sub" for the "on click"
event, and my OpenEmployeeReport is the sole command for the sub. I'm
assuming that's how you program that button....

No problem there
1. In MDB1 You have a form with a text box called employeeNum containing
employee Num, and a button that run a function OpenEmployeeReport (
me.employeeNum)

2. in MDB2 create a function
Function OpenEmployeeReport ( employeeNum as long)
docmd.openreport "ReportName",,, "[Employeenum] = " & employeeNum
End Function

3. Open The refernce in MDB1 (open code any where, go to tools, reference)
browse and select MDB2.

4. Now run the form and click the button, it should run the function you
created in MDB2.

note:
if you make changes to MDB2 and MDB1 is open, you have to close MDB1 so it
will recognise the changes you made.

Also, is this creating a reference to another DB something that can be done

From one DB you can create a reference to another DB, the main DB will
recognise all the functions in the link DB.

In the link Db you can create a function that get a parameter and open a
report using this parameter.



:

Okay, so no one was able to help you with my prior idea of asking Access to
open a report in an different database.

http://www.microsoft.com/office/com...06a3&mid=e82a4613-cdf9-4f7b-b8ea-e2a6288206a3

I was able to get the database open, but when giving commands to open a
report, it wants to look in the database where we started. Fair enough.

My workaround will now be to open the database, have a form that opens on
startup which will automatically forward to the report in this other database.

So.... if I'm in a general "Customer" form on Database #1, looking at
"[CustomerID]=15", how do I pass that [CustomerID] variable to Database#2
when I ask Database#1 to open it?

 

[Guest]

Sure....

In DB1 -

Private Sub cmdprevrptDistrictProfileRedo_Click()

OpenReportCard (Me.DistrictID)

End Sub
-------------------------------------
IN DB2 -

Public Function OpenReportCard(DistrictID As Long)

DoCmd.OpenReport "rptDistrictProfile2005Ind", , , "[DistrictID]= " &
DistrictID

End Function
-------------------------------------

can you post the code you created in both mdb.

When I try to run it, I get a "sub or function not defined" error.

Any ideas? When I program the button, it creates a "sub" for the "on click"
event, and my OpenEmployeeReport is the sole command for the sub. I'm
assuming that's how you program that button....

No problem there
1. In MDB1 You have a form with a text box called employeeNum containing
employee Num, and a button that run a function OpenEmployeeReport (
me.employeeNum)

2. in MDB2 create a function
Function OpenEmployeeReport ( employeeNum as long)
docmd.openreport "ReportName",,, "[Employeenum] = " & employeeNum
End Function

3. Open The refernce in MDB1 (open code any where, go to tools, reference)
browse and select MDB2.

4. Now run the form and click the button, it should run the function you
created in MDB2.

note:
if you make changes to MDB2 and MDB1 is open, you have to close MDB1 so it
will recognise the changes you made.

:

Also, is this creating a reference to another DB something that can be done
on Access 2000?

:

From one DB you can create a reference to another DB, the main DB will
recognise all the functions in the link DB.

In the link Db you can create a function that get a parameter and open a
report using this parameter.



:

Okay, so no one was able to help you with my prior idea of asking Access to
open a report in an different database.

http://www.microsoft.com/office/com...06a3&mid=e82a4613-cdf9-4f7b-b8ea-e2a6288206a3

I was able to get the database open, but when giving commands to open a
report, it wants to look in the database where we started. Fair enough.

My workaround will now be to open the database, have a form that opens on
startup which will automatically forward to the report in this other database.

So.... if I'm in a general "Customer" form on Database #1, looking at
"[CustomerID]=15", how do I pass that [CustomerID] variable to Database#2
when I ask Database#1 to open it?

 

[Guest]

Private Sub cmdprevrptDistrictProfileRedo_Click()

OpenReportCard Me.DistrictID

End Sub
--------------------------

Same error message....

Write the call for the function like that

OpenReportCard Me.DistrictID

other wise it search for a sub

Sure....

In DB1 -

Private Sub cmdprevrptDistrictProfileRedo_Click()

OpenReportCard (Me.DistrictID)

End Sub
-------------------------------------
IN DB2 -

Public Function OpenReportCard(DistrictID As Long)

DoCmd.OpenReport "rptDistrictProfile2005Ind", , , "[DistrictID]= " &
DistrictID

End Function
-------------------------------------

can you post the code you created in both mdb.

:

When I try to run it, I get a "sub or function not defined" error.

Any ideas? When I program the button, it creates a "sub" for the "on click"
event, and my OpenEmployeeReport is the sole command for the sub. I'm
assuming that's how you program that button....

:

No problem there
1. In MDB1 You have a form with a text box called employeeNum containing
employee Num, and a button that run a function OpenEmployeeReport (
me.employeeNum)

2. in MDB2 create a function
Function OpenEmployeeReport ( employeeNum as long)
docmd.openreport "ReportName",,, "[Employeenum] = " & employeeNum
End Function

3. Open The refernce in MDB1 (open code any where, go to tools, reference)
browse and select MDB2.

4. Now run the form and click the button, it should run the function you
created in MDB2.

note:
if you make changes to MDB2 and MDB1 is open, you have to close MDB1 so it
will recognise the changes you made.

:

Also, is this creating a reference to another DB something that can be done
on Access 2000?

:

From one DB you can create a reference to another DB, the main DB will
recognise all the functions in the link DB.

In the link Db you can create a function that get a parameter and open a
report using this parameter.



:

Okay, so no one was able to help you with my prior idea of asking Access to
open a report in an different database.

http://www.microsoft.com/office/com...06a3&mid=e82a4613-cdf9-4f7b-b8ea-e2a6288206a3

I was able to get the database open, but when giving commands to open a
report, it wants to look in the database where we started. Fair enough.

My workaround will now be to open the database, have a form that opens on
startup which will automatically forward to the report in this other database.

So.... if I'm in a general "Customer" form on Database #1, looking at
"[CustomerID]=15", how do I pass that [CustomerID] variable to Database#2
when I ask Database#1 to open it?

 

[Guest]

It doesnt make sense, the problem can be that there is no refernce from MDB1
to MDB2

Private Sub cmdprevrptDistrictProfileRedo_Click()

OpenReportCard Me.DistrictID

End Sub
--------------------------

Same error message....

Write the call for the function like that

OpenReportCard Me.DistrictID

other wise it search for a sub

Sure....

In DB1 -

Private Sub cmdprevrptDistrictProfileRedo_Click()

OpenReportCard (Me.DistrictID)

End Sub
-------------------------------------
IN DB2 -

Public Function OpenReportCard(DistrictID As Long)

DoCmd.OpenReport "rptDistrictProfile2005Ind", , , "[DistrictID]= " &
DistrictID

End Function
-------------------------------------

:

can you post the code you created in both mdb.

:

When I try to run it, I get a "sub or function not defined" error.

Any ideas? When I program the button, it creates a "sub" for the "on click"
event, and my OpenEmployeeReport is the sole command for the sub. I'm
assuming that's how you program that button....

:

No problem there
1. In MDB1 You have a form with a text box called employeeNum containing
employee Num, and a button that run a function OpenEmployeeReport (
me.employeeNum)

2. in MDB2 create a function
Function OpenEmployeeReport ( employeeNum as long)
docmd.openreport "ReportName",,, "[Employeenum] = " & employeeNum
End Function

3. Open The refernce in MDB1 (open code any where, go to tools, reference)
browse and select MDB2.

4. Now run the form and click the button, it should run the function you
created in MDB2.

note:
if you make changes to MDB2 and MDB1 is open, you have to close MDB1 so it
will recognise the changes you made.

:

Also, is this creating a reference to another DB something that can be done
on Access 2000?

:

From one DB you can create a reference to another DB, the main DB will
recognise all the functions in the link DB.

In the link Db you can create a function that get a parameter and open a
report using this parameter.



:

Okay, so no one was able to help you with my prior idea of asking Access to
open a report in an different database.

http://www.microsoft.com/office/com...06a3&mid=e82a4613-cdf9-4f7b-b8ea-e2a6288206a3

I was able to get the database open, but when giving commands to open a
report, it wants to look in the database where we started. Fair enough.

My workaround will now be to open the database, have a form that opens on
startup which will automatically forward to the report in this other database.

So.... if I'm in a general "Customer" form on Database #1, looking at
"[CustomerID]=15", how do I pass that [CustomerID] variable to Database#2
when I ask Database#1 to open it?

 

[Guest]

The reference is there. When I open and look to edit vB script on MDB2, it
tells me that the database is in use and I can't make changes. Also, if I
try to add a reference going the other way, it tells me I can't make circular
references.

The OpenReport function works when I call it within DB2, so it's not a
problem with the function itself.

It is a problem with the reference, and recognizing the Function, it seems.
When I look at the OpenReport function on DB2, it seems to associate it with
a form on that database. Do I need to create a module or change some
setting? Or do they automatically group code like that?


Any ideas on someone we can rope into this discussion who might have worked
quite a bit with references?

It doesnt make sense, the problem can be that there is no refernce from MDB1
to MDB2

Private Sub cmdprevrptDistrictProfileRedo_Click()

OpenReportCard Me.DistrictID

End Sub
--------------------------

Same error message....

Write the call for the function like that

OpenReportCard Me.DistrictID

other wise it search for a sub

:

Sure....

In DB1 -

Private Sub cmdprevrptDistrictProfileRedo_Click()

OpenReportCard (Me.DistrictID)

End Sub
-------------------------------------
IN DB2 -

Public Function OpenReportCard(DistrictID As Long)

DoCmd.OpenReport "rptDistrictProfile2005Ind", , , "[DistrictID]= " &
DistrictID

End Function
-------------------------------------

:

can you post the code you created in both mdb.

:

When I try to run it, I get a "sub or function not defined" error.

Any ideas? When I program the button, it creates a "sub" for the "on click"
event, and my OpenEmployeeReport is the sole command for the sub. I'm
assuming that's how you program that button....

:

No problem there
1. In MDB1 You have a form with a text box called employeeNum containing
employee Num, and a button that run a function OpenEmployeeReport (
me.employeeNum)

2. in MDB2 create a function
Function OpenEmployeeReport ( employeeNum as long)
docmd.openreport "ReportName",,, "[Employeenum] = " & employeeNum
End Function

3. Open The refernce in MDB1 (open code any where, go to tools, reference)
browse and select MDB2.

4. Now run the form and click the button, it should run the function you
created in MDB2.

note:
if you make changes to MDB2 and MDB1 is open, you have to close MDB1 so it
will recognise the changes you made.

:

Also, is this creating a reference to another DB something that can be done
on Access 2000?

:

From one DB you can create a reference to another DB, the main DB will
recognise all the functions in the link DB.

In the link Db you can create a function that get a parameter and open a
report using this parameter.



:

Okay, so no one was able to help you with my prior idea of asking Access to
open a report in an different database.

http://www.microsoft.com/office/com...06a3&mid=e82a4613-cdf9-4f7b-b8ea-e2a6288206a3

I was able to get the database open, but when giving commands to open a
report, it wants to look in the database where we started. Fair enough.

My workaround will now be to open the database, have a form that opens on
startup which will automatically forward to the report in this other database.

So.... if I'm in a general "Customer" form on Database #1, looking at
"[CustomerID]=15", how do I pass that [CustomerID] variable to Database#2
when I ask Database#1 to open it?

 

[Guest]

It looks like the problems was with where I built the function.

Since I just opened VB up, it attached the function, even as a Public
function, to the one form on that database.

While working at this from another angle, I found that creating a module,
and putting the functions there allowed them to be recognized, so maybe that
was the problem.

Thanks very, very much for all your time and effort. Even though your
solution wasn't my final one, it taught me a lot.

It doesnt make sense, the problem can be that there is no refernce from MDB1
to MDB2

Private Sub cmdprevrptDistrictProfileRedo_Click()

OpenReportCard Me.DistrictID

End Sub
--------------------------

Same error message....

Write the call for the function like that

OpenReportCard Me.DistrictID

other wise it search for a sub

:

Sure....

In DB1 -

Private Sub cmdprevrptDistrictProfileRedo_Click()

OpenReportCard (Me.DistrictID)

End Sub
-------------------------------------
IN DB2 -

Public Function OpenReportCard(DistrictID As Long)

DoCmd.OpenReport "rptDistrictProfile2005Ind", , , "[DistrictID]= " &
DistrictID

End Function
-------------------------------------

:

can you post the code you created in both mdb.

:

When I try to run it, I get a "sub or function not defined" error.

Any ideas? When I program the button, it creates a "sub" for the "on click"
event, and my OpenEmployeeReport is the sole command for the sub. I'm
assuming that's how you program that button....

:

No problem there
1. In MDB1 You have a form with a text box called employeeNum containing
employee Num, and a button that run a function OpenEmployeeReport (
me.employeeNum)

2. in MDB2 create a function
Function OpenEmployeeReport ( employeeNum as long)
docmd.openreport "ReportName",,, "[Employeenum] = " & employeeNum
End Function

3. Open The refernce in MDB1 (open code any where, go to tools, reference)
browse and select MDB2.

4. Now run the form and click the button, it should run the function you
created in MDB2.

note:
if you make changes to MDB2 and MDB1 is open, you have to close MDB1 so it
will recognise the changes you made.

:

Also, is this creating a reference to another DB something that can be done
on Access 2000?

:

From one DB you can create a reference to another DB, the main DB will
recognise all the functions in the link DB.

In the link Db you can create a function that get a parameter and open a
report using this parameter.



:

Okay, so no one was able to help you with my prior idea of asking Access to
open a report in an different database.

http://www.microsoft.com/office/com...06a3&mid=e82a4613-cdf9-4f7b-b8ea-e2a6288206a3

I was able to get the database open, but when giving commands to open a
report, it wants to look in the database where we started. Fair enough.

My workaround will now be to open the database, have a form that opens on
startup which will automatically forward to the report in this other database.

So.... if I'm in a general "Customer" form on Database #1, looking at
"[CustomerID]=15", how do I pass that [CustomerID] variable to Database#2
when I ask Database#1 to open it?

 

[Guest]

I've been working for the last four years with reference.
I have the main MDB with reference to 10 other MDB

One more question, did you create the function in a module?
If not then create it in a module, and not under a form.

It looks like the problems was with where I built the function.

Since I just opened VB up, it attached the function, even as a Public
function, to the one form on that database.

While working at this from another angle, I found that creating a module,
and putting the functions there allowed them to be recognized, so maybe that
was the problem.

Thanks very, very much for all your time and effort. Even though your
solution wasn't my final one, it taught me a lot.

It doesnt make sense, the problem can be that there is no refernce from MDB1
to MDB2

Private Sub cmdprevrptDistrictProfileRedo_Click()

OpenReportCard Me.DistrictID

End Sub
--------------------------

Same error message....

:

Write the call for the function like that

OpenReportCard Me.DistrictID

other wise it search for a sub

:

Sure....

In DB1 -

Private Sub cmdprevrptDistrictProfileRedo_Click()

OpenReportCard (Me.DistrictID)

End Sub
-------------------------------------
IN DB2 -

Public Function OpenReportCard(DistrictID As Long)

DoCmd.OpenReport "rptDistrictProfile2005Ind", , , "[DistrictID]= " &
DistrictID

End Function
-------------------------------------

:

can you post the code you created in both mdb.

:

When I try to run it, I get a "sub or function not defined" error.

Any ideas? When I program the button, it creates a "sub" for the "on click"
event, and my OpenEmployeeReport is the sole command for the sub. I'm
assuming that's how you program that button....

:

No problem there
1. In MDB1 You have a form with a text box called employeeNum containing
employee Num, and a button that run a function OpenEmployeeReport (
me.employeeNum)

2. in MDB2 create a function
Function OpenEmployeeReport ( employeeNum as long)
docmd.openreport "ReportName",,, "[Employeenum] = " & employeeNum
End Function

3. Open The refernce in MDB1 (open code any where, go to tools, reference)
browse and select MDB2.

4. Now run the form and click the button, it should run the function you
created in MDB2.

note:
if you make changes to MDB2 and MDB1 is open, you have to close MDB1 so it
will recognise the changes you made.

:

Also, is this creating a reference to another DB something that can be done
on Access 2000?

:

From one DB you can create a reference to another DB, the main DB will
recognise all the functions in the link DB.

In the link Db you can create a function that get a parameter and open a
report using this parameter.



:

Okay, so no one was able to help you with my prior idea of asking Access to
open a report in an different database.

http://www.microsoft.com/office/com...06a3&mid=e82a4613-cdf9-4f7b-b8ea-e2a6288206a3

I was able to get the database open, but when giving commands to open a
report, it wants to look in the database where we started. Fair enough.

My workaround will now be to open the database, have a form that opens on
startup which will automatically forward to the report in this other database.

So.... if I'm in a general "Customer" form on Database #1, looking at
"[CustomerID]=15", how do I pass that [CustomerID] variable to Database#2
when I ask Database#1 to open it?

 

[Guest]

Ofer - I put another post up there IDing the problem as my not creating a
module for it, initially. However, I also found a different way around this
problem using command line switches.