Next Record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sturner333 - 29 Mar 2006 16:19 GMT

Newbie Question:
What is the event that takes place(so I can do some VBA code) when you click
the arrow on the form to go to the next record?
Thanks

Reply to this Message

Rick B - 29 Mar 2006 16:49 GMT

You can use the button wizard to add a button that takes the user to the
next record. You can then take a look at the code it creates. (If you want
to find the answer yourself, or similar ones in the future.)

To answer your question, it is...

DoCmd.GoToRecord , , acNext

Signature

Rick B

> Newbie Question:
> What is the event that takes place(so I can do some VBA code) when you
> click
> the arrow on the form to go to the next record?
> Thanks

Reply to this Message

Rick B - 29 Mar 2006 16:59 GMT

Sorry, you were asking about the event, not how to do it. I think the other
post answers your question. You are most likely looking for the "Current"
event if you want something to fire as you move from one record to another
(whether forward or backward, or using a search of some kind to jump right
to a record).

Signature

Rick B

> You can use the button wizard to add a button that takes the user to the
> next record. You can then take a look at the code it creates. (If you
[quoted text clipped - 9 lines]
>> the arrow on the form to go to the next record?
>> Thanks

Reply to this Message

Klatuu - 29 Mar 2006 17:21 GMT

LOL I puzzled at your first post, Rick.
I, of course, have never misread a post and responded with a meaningless
answer:)

The Current event was also my first thought, but then it really does depend
on what he wants to do. It could be the Before Update, the After Update, or
the Current.

Two of my favorite events are Before Nap and After Nap. Unlike most similar
events, the Before Nap cannot be canceled but the After Nap can.

The After Nap event can be recursive if you set the Timer event.

> Sorry, you were asking about the event, not how to do it. I think the other
> post answers your question. You are most likely looking for the "Current"
[quoted text clipped - 15 lines]
> >> the arrow on the form to go to the next record?
> >> Thanks

Reply to this Message

sturner333 - 29 Mar 2006 17:41 GMT

I am still having trouble with this. When each new record is diplayed on the
from, I want to look to see if a check box is checked. If it is, I want to
lock the check box so as to not be changed, until the next record
re-eveluates the check box.
Thanks ofr the help.

> LOL I puzzled at your first post, Rick.
> I, of course, have never misread a post and responded with a meaningless
[quoted text clipped - 28 lines]
> > >> the arrow on the form to go to the next record?
> > >> Thanks

Reply to this Message

Ken Sheridan - 29 Mar 2006 18:17 GMT

The appropriate event would be the form's Current event. As a bound check
box's value is a Boolean True or False you can set its locked property with a
single line in the form's Current event procedure:

Me.YourCheckBox.Locked = Me.YourCheckBox

Ken Sheridan
Stafford, England

> I am still having trouble with this. When each new record is diplayed on the
> from, I want to look to see if a check box is checked. If it is, I want to
> lock the check box so as to not be changed, until the next record
> re-eveluates the check box.
> Thanks ofr the help.

Reply to this Message

Klatuu - 29 Mar 2006 19:13 GMT

Then the Current event of the form is the correct place to do this. It would
be something like:
Me.MyCheckbox.Locked = Me.MyCheckbox

This will cause the check box to lokc if it is checked and Unlock if it is
not.

> I am still having trouble with this. When each new record is diplayed on the
> from, I want to look to see if a check box is checked. If it is, I want to
[quoted text clipped - 34 lines]
> > > >> the arrow on the form to go to the next record?
> > > >> Thanks

Reply to this Message

Klatuu - 29 Mar 2006 16:50 GMT

There are several. Which you use depends on what you want to do. Here is a
site that might be hepful to you:

http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP051867611033

If that doesn't answer your question, post back with what you want to happen
when you mover off the current record, and we can find the correct event.

> Newbie Question:
> What is the event that takes place(so I can do some VBA code) when you click
> the arrow on the form to go to the next record?
> Thanks

Reply to this Message