ADP - Input Parameters from more than one form

[isaacrajan]

Hello,

I have a form A in my ADP project. The record source of A has input
parameters.

I need to open form A from three different forms X, Y and Z.

When I open A from form X, I want it to take input parameters from form
X.
When I open A from form Y, I want it to take input parameters from form
Y.
When I open A from form Z, I want it to take input parameters from form
Z.

How do I accomplish this?

Thanks,

Isaac

[Steve Jorgensen]

Probably the easiest way it to pass the calling form name to form A via
OpenArgs, then have A generate a SQL string for its RecordSource property by
reading values from controls on the source form.

I usually don't like embedding parameter values in SQL when it can reasonably
be avoided, but I've used ADPs enough to know that any other way you might
attempt to do this is bound to be quirky and cause you massive headaches.

On 9 Dec 2004 00:56:42 -0800, is********@yahoo.com wrote:

Hello,

I have a form A in my ADP project. The record source of A has input
parameters.

I need to open form A from three different forms X, Y and Z.

When I open A from form X, I want it to take input parameters from form
X.
When I open A from form Y, I want it to take input parameters from form
Y.
When I open A from form Z, I want it to take input parameters from form
Z.

How do I accomplish this?

Thanks,

Isaac

[isaacrajan]

Thank you Steve! I now plan to use OpenArgs and use it in the On Open
event of the form to generate an appropirate SQL statement that
executes a stored procedure with the required parameters. As you
suggested then I plan to assign the generated SQL string as the
RecordSource of the form.

Thanks,

Isaac

Steve Jorgensen wrote:

Probably the easiest way it to pass the calling form name to form A via OpenArgs, then have A generate a SQL string for its RecordSource property by reading values from controls on the source form.

I usually don't like embedding parameter values in SQL when it can reasonably be avoided, but I've used ADPs enough to know that any other way you might attempt to do this is bound to be quirky and cause you massive headaches.
On 9 Dec 2004 00:56:42 -0800, is********@yahoo.com wrote:

Hello,

I have a form A in my ADP project. The record source of A has input
parameters.

I need to open form A from three different forms X, Y and Z.

When I open A from form X, I want it to take input parameters from formX.
When I open A from form Y, I want it to take input parameters from formY.
When I open A from form Z, I want it to take input parameters from formZ.

How do I accomplish this?

Thanks,

Isaac

[Steve Jorgensen]

Let us know how it goes.

On 9 Dec 2004 20:01:58 -0800, is********@yahoo.com wrote:

Thank you Steve! I now plan to use OpenArgs and use it in the On Open
event of the form to generate an appropirate SQL statement that
executes a stored procedure with the required parameters. As you
suggested then I plan to assign the generated SQL string as the
RecordSource of the form.

Thanks,

Isaac

Steve Jorgensen wrote:

Probably the easiest way it to pass the calling form name to form A

via

OpenArgs, then have A generate a SQL string for its RecordSource

property by

reading values from controls on the source form.

I usually don't like embedding parameter values in SQL when it can

reasonably

be avoided, but I've used ADPs enough to know that any other way you

might

attempt to do this is bound to be quirky and cause you massive

headaches.

On 9 Dec 2004 00:56:42 -0800, is********@yahoo.com wrote:

>Hello,
>
>I have a form A in my ADP project. The record source of A has input
>parameters.
>
>I need to open form A from three different forms X, Y and Z.
>
>When I open A from form X, I want it to take input parameters fromform >X.
>When I open A from form Y, I want it to take input parameters fromform >Y.
>When I open A from form Z, I want it to take input parameters fromform >Z.
>
>How do I accomplish this?
>
>Thanks,
>
>Isaac

[isaacrajan]

Sure :-)

Steve Jorgensen wrote:

Let us know how it goes.

On 9 Dec 2004 20:01:58 -0800, is********@yahoo.com wrote:

Thank you Steve! I now plan to use OpenArgs and use it in the On Openevent of the form to generate an appropirate SQL statement that
executes a stored procedure with the required parameters. As you
suggested then I plan to assign the generated SQL string as the
RecordSource of the form.

Thanks,

Isaac

Steve Jorgensen wrote:

Probably the easiest way it to pass the calling form name to form A

via

OpenArgs, then have A generate a SQL string for its RecordSource

property by

reading values from controls on the source form.

I usually don't like embedding parameter values in SQL when it can

reasonably

be avoided, but I've used ADPs enough to know that any other way

youmight

attempt to do this is bound to be quirky and cause you massive

headaches.

On 9 Dec 2004 00:56:42 -0800, is********@yahoo.com wrote:

>Hello,
>
>I have a form A in my ADP project. The record source of A has

input >parameters.
>
>I need to open form A from three different forms X, Y and Z.
>
>When I open A from form X, I want it to take input parameters

fromform

>X.
>When I open A from form Y, I want it to take input parameters

fromform

>Y.
>When I open A from form Z, I want it to take input parameters

fromform

>Z.
>
>How do I accomplish this?
>
>Thanks,
>
>Isaac

[isaacrajan]

Hello,

I tried passing a string through OpenArgs and tried to change the
record source of the form based on the argument passed. I get an error
message saying the Open form action was cancelled. Does this have
something to do with the (Cancel as integer) in brackets in the sub
routine? I tried removing this and setting the value of Cancel to
false, inspite of this the error continues to appear. Any solutions?

Thanks

Isaac
Steve Jorgensen wrote:

Let us know how it goes.

On 9 Dec 2004 20:01:58 -0800, is********@yahoo.com wrote:

Thank you Steve! I now plan to use OpenArgs and use it in the On Openevent of the form to generate an appropirate SQL statement that
executes a stored procedure with the required parameters. As you
suggested then I plan to assign the generated SQL string as the
RecordSource of the form.

Thanks,

Isaac

Steve Jorgensen wrote:

Probably the easiest way it to pass the calling form name to form A

via

OpenArgs, then have A generate a SQL string for its RecordSource

property by

reading values from controls on the source form.

I usually don't like embedding parameter values in SQL when it can

reasonably

be avoided, but I've used ADPs enough to know that any other way

youmight

attempt to do this is bound to be quirky and cause you massive

headaches.

On 9 Dec 2004 00:56:42 -0800, is********@yahoo.com wrote:

>Hello,
>
>I have a form A in my ADP project. The record source of A has

input >parameters.
>
>I need to open form A from three different forms X, Y and Z.
>
>When I open A from form X, I want it to take input parameters

fromform

>X.
>When I open A from form Y, I want it to take input parameters

fromform

>Y.
>When I open A from form Z, I want it to take input parameters

fromform

>Z.
>
>How do I accomplish this?
>
>Thanks,
>
>Isaac