Re: me.undo

Tech-Archive recommends: Fix windows errors by optimizing your registry

I would like to see it. Will you zip it and email it to comprev@xxxxxxxxxxx?

--
Wayne Morgan
MS Access MVP


"Trini Gal" <TriniGal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:17144707-0E74-45B8-8042-BCC63EE63CEC@xxxxxxxxxxxxxxxx
> Wayne,
>
> First of all, thanks for explaining Recordset Clone and Bookmarks to me,
> as
> I said I am a total newbie at this VB thing.
>
> Second, that code you gave me to put in the OnError Event, was it supposed
> to create a pop up box? If it was, there was no pop up box. There is no
> other code in this subform. There is however code in the main form but
> none
> of it is in the OnCurrent Event.
>
> I'm sorry, this is such a headache. Any other ideas?
>
> Thank you so much for your help and patience.
>
> "Wayne Morgan" wrote:
>
>> You used to have to use a recordset clone and bookmarks, but the new
>> versions of Access let you address the form's recordset directly.
>> Besides,
>> when you set the form's bookmark to the clone's bookmark, you're still
>> going
>> to move to that record and the error will occur. Using the clone has the
>> advantage of not moving the form to the record it you want to work on
>> that
>> record but leave the form's display where it is.
>>
>> Place the following in the form's Error event and see what happens:
>>
>> MsgBox "The Error Number is " & DataErr
>>
>> If this comes up, then this is where we can handle the error. Is there
>> any
>> other code in that form? Perhaps in the Current event?
>>
>> --
>> Wayne Morgan
>> MS Access MVP
>>
>>
>> "Trini Gal" <TriniGal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:62E3E26A-E23A-41A2-A453-47A37F61664D@xxxxxxxxxxxxxxxx
>> > Also,
>> >
>> > Like I said, I had posted this message before in the forms section and
>> > someone mentioned that I need to use a recordset clone and bookmarks,
>> > but
>> > I
>> > don't
>> > know how to do it.
>> >
>> > You wouldn't by chance know how to do that do you?
>>
>>
>>


.

Quantcast