This one had me stymied for a minute. Clicking the button it was attached
to seemingly did nothing.
=============================
On Error GoTo exitGetData
...code that threw an error...
exitGetData:
DoCmd.Hourglass False
Exit Sub
errGetData:
MsgBox "Error " & Err.Number & ": " & Err.Description
Resume exitGetData
=============================
Anthony England - 08 Feb 2006 23:26 GMT
> This one had me stymied for a minute. Clicking the button it was attached
> to seemingly did nothing.
[quoted text clipped - 13 lines]
>
> =============================
Well I guess you know by now: <On Error GoTo exitGetData> should probably
be <On Error GoTo errGetData>
Rick Brandt - 09 Feb 2006 00:20 GMT
> > This one had me stymied for a minute. Clicking the button it was
> > attached to seemingly did nothing.
[quoted text clipped - 16 lines]
> Well I guess you know by now: <On Error GoTo exitGetData> should
> probably be <On Error GoTo errGetData>
A good argument for always using the same labels for error handler and exit
point.

Signature
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Wayne Gillespie - 08 Feb 2006 23:36 GMT
>This one had me stymied for a minute. Clicking the button it was attached
>to seemingly did nothing.
>
>=============================
>On Error GoTo exitGetData
On Error GoTo errGetData
>...code that threw an error...
>
[quoted text clipped - 7 lines]
>
>=============================
Wayne Gillespie
Gosford NSW Australia