From: dirtrhoads on
I have set up an OpenForm macro on a double click event in a subform. The
subform is titled Active Orders at Belmont Subform. The form I have set to
open is Order Details. I have set up the macro to open Order Details when I
click on the PO_Number from my subform and it opens perfect, however, I want
it to open up to the record I double clicked. As of right now, it is opening
up to the first record. I tried typing in PO_Number in the WHERE clause but
this caused the event to open up to a New Record...

Can you please let me know what I need to do in order to have this open up
to the selected record?

Thank you,
Amy
From: Wolfgang Kais on
Hello Amy.

"dirtrhoads" (Amy) wrote:
> I have set up an OpenForm macro on a double click event in a subform.
> The subform is titled Active Orders at Belmont Subform. The form I
> have set to open is Order Details. I have set up the macro to open
> Order Details when I click on the PO_Number from my subform and it
> opens perfect, however, I want it to open up to the record I double
> clicked. As of right now, it is opening up to the first record.
> I tried typing in PO_Number in the WHERE clause but this caused the
> event to open up to a New Record...

The WHERE clause sould have the form "PO_Number = 123". Since the number
depends on a field of the current record, this WHERE clause has to be
calculated. Try something like this in the argument:
="PO_Number = " & [PO_Number]

--
Regards,
Wolfgang


From: dirtrhoads on
Wolfgang,

Thank you for your suggestion, but unfortunately that didn't work. When it
entered it exactly as you had it it gave me an error that says "You may have
specified a control that wasn't on the current object without specifying the
correct form or report context". So I entered this into the WHERE clause:

="PO_Number = " & [Forms]![Order Details]![PO_Number]

but this gave me another error stating that form i referenced was either
closed or did not exist.

So, i opened the form, minimized it and then ran the macro again and it
asked me for a parameter and I'm assuming this is because my PO Numbers are
alpha numeric...?

I'd like to be able to double click the PO Number from subform without
having to have Order Details open/minimized, and also not to have to enter
the Alpha parameter... will this be possible?

Thanks you,
Amy

"Wolfgang Kais" wrote:

> Hello Amy.
>
> "dirtrhoads" (Amy) wrote:
> > I have set up an OpenForm macro on a double click event in a subform.
> > The subform is titled Active Orders at Belmont Subform. The form I
> > have set to open is Order Details. I have set up the macro to open
> > Order Details when I click on the PO_Number from my subform and it
> > opens perfect, however, I want it to open up to the record I double
> > clicked. As of right now, it is opening up to the first record.
> > I tried typing in PO_Number in the WHERE clause but this caused the
> > event to open up to a New Record...
>
> The WHERE clause sould have the form "PO_Number = 123". Since the number
> depends on a field of the current record, this WHERE clause has to be
> calculated. Try something like this in the argument:
> ="PO_Number = " & [PO_Number]
>
> --
> Regards,
> Wolfgang
>
>
> .
>
From: Wolfgang Kais on
Hello Amy.

"dirtrhoads" (Amy) wrote:
>>> I have set up an OpenForm macro on a double click event in a subform.
>>> The subform is titled Active Orders at Belmont Subform. The form I
>>> have set to open is Order Details. I have set up the macro to open
>>> Order Details when I click on the PO_Number from my subform and it
>>> opens perfect, however, I want it to open up to the record I double
>>> clicked. As of right now, it is opening up to the first record.
>>> I tried typing in PO_Number in the WHERE clause but this caused the
>>> event to open up to a New Record...

Wolfgang answered:
>> The WHERE clause sould have the form "PO_Number = 123". Since the
>> number depends on a field of the current record, this WHERE clause has
>> to be calculated. Try something like this in the argument:
>> ="PO_Number = " & [PO_Number]

"dirtrhoads" came back:
> Wolfgang,
>
> Thank you for your suggestion, but unfortunately that didn't work. When
> I entered it exactly as you had it it gave me an error that says "You
> may have specified a control that wasn't on the current object without
> specifying the correct form or report context".

Try replacing the name in [PO_Number] by the correct name of the
corresponding control on the subform.

> So I entered this into the WHERE clause:
>
> ="PO_Number = " & [Forms]![Order Details]![PO_Number]
>
> but this gave me another error stating that form i referenced was
> either closed or did not exist.

Here, you have referenced a control on the form that you were going to
open. You should have referenced the control on the subform that contains
the PO_Number that you want to use in the WHERE clause.

> So, i opened the form, minimized it and then ran the macro again and it
> asked me for a parameter and I'm assuming this is because my PO Numbers
> are alpha numeric...?

I don't think so, but probably the record sorce for the Order Details form
does not contain a field named PO_Number. Verify the name of the field and
correct the first part of the WHERE clause argument:
="[correct field name] = " & ...
Since your field seems to be of type text, try the following:
="[correct field name] = '" & [correct control name] & "'"

> I'd like to be able to double click the PO Number from subform without
> having to have Order Details open/minimized, and also not to have to
> enter the Alpha parameter... will this be possible?

Sure. Try my suggestions and the we'll see. If this dosn't work either,
try to replace [correct control name] by the complete path to the control:
[Forms]![name of main form]![name of subform control].Form![correct control
name]

--
Regards,
Wolfgang


From: Endo on

"dirtrhoads" <dirtrhoads(a)discussions.microsoft.com> wrote in message
news:FE05F4CB-006D-4891-BA95-0FA20E875115(a)microsoft.com...
>I have set up an OpenForm macro on a double click event in a subform. The
> subform is titled Active Orders at Belmont Subform. The form I have set to
> open is Order Details. I have set up the macro to open Order Details when
> I
> click on the PO_Number from my subform and it opens perfect, however, I
> want
> it to open up to the record I double clicked. As of right now, it is
> opening
> up to the first record. I tried typing in PO_Number in the WHERE clause
> but
> this caused the event to open up to a New Record...
>
> Can you please let me know what I need to do in order to have this open up
> to the selected record?
>
> Thank you,
> Amy