How to prevent my for going to 1st record in table…

[Dody]

Hello

How to prevent my for going to 1st record in table…??
Thank you

 

[John Big Booty]

I'm not sure why you would want to do that, but the following code will do the trick if you put it in your Form's On Current Event;

    If Me.CurrentRecord = 1 Then
        DoCmd.GoToRecord acDataForm, "YourFormName", acNext
    End If

 

[vbaInet]

You may also want to count the records before moving next or have Resume Next in your error handler.

 

[missinglinq]

Where do you want the for to go when opening?

 

[HiTechCoach]

Hello

How to prevent my for going to 1st record in table…??
Thank you

I am really curious why you would want to do this. +ould you mind explaing?

if you do not want a specific record to show, you could filter it out in the rrcord source.