Hi I'm using the following to go to the next record. However I like that it
creates a new record when it gets to the end of the list but I don't want the
user to be able to just keep clicking next and creating many blank records.
Is there any way around this?

Private Sub Command116_Click()
On Error GoTo Err_Command116_Click


DoCmd.GoToRecord , , acNext

Exit_Command116_Click:
Exit Sub

Err_Command116_Click:
MsgBox Err.Description
Resume Exit_Command116_Click

End Sub

On my other form using the same code it says you can't go to the specified
record, which is what I'd like it to say


"Emma" wrote:

> Hi I'm using the following to go to the next record. However I like that it
> creates a new record when it gets to the end of the list but I don't want the
> user to be able to just keep clicking next and creating many blank records.
> Is there any way around this?
>
> Private Sub Command116_Click()
> On Error GoTo Err_Command116_Click
>
>
> DoCmd.GoToRecord , , acNext
>
> Exit_Command116_Click:
> Exit Sub
>
> Err_Command116_Click:
> MsgBox Err.Description
> Resume Exit_Command116_Click
>
> End Sub

Hi Emma

This won't happen, unless you have some code somewhere that writes data into
a new record, thereby making it dirty.

If you are already on a new, undirtied record, a request to go to the next
record will do nothing.
--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

"Emma" <(E-Mail Removed)> wrote in message
news:692C84C9-277A-4A50-AAE8-(E-Mail Removed)...
> Hi I'm using the following to go to the next record. However I like that
> it
> creates a new record when it gets to the end of the list but I don't want
> the
> user to be able to just keep clicking next and creating many blank
> records.
> Is there any way around this?
>
> Private Sub Command116_Click()
> On Error GoTo Err_Command116_Click
>
>
> DoCmd.GoToRecord , , acNext
>
> Exit_Command116_Click:
> Exit Sub
>
> Err_Command116_Click:
> MsgBox Err.Description
> Resume Exit_Command116_Click
>
> End Sub

Yes I was trying to write the current users name into the new record, once I
got rid of that code it worked, thanks alot! I now know what a dirty record
is,thanks


"Graham Mandeno" wrote:

> Hi Emma
>
> This won't happen, unless you have some code somewhere that writes data into
> a new record, thereby making it dirty.
>
> If you are already on a new, undirtied record, a request to go to the next
> record will do nothing.
> --
> Good Luck :-)
>
> Graham Mandeno [Access MVP]
> Auckland, New Zealand
>
> "Emma" <(E-Mail Removed)> wrote in message
> news:692C84C9-277A-4A50-AAE8-(E-Mail Removed)...
> > Hi I'm using the following to go to the next record. However I like that
> > it
> > creates a new record when it gets to the end of the list but I don't want
> > the
> > user to be able to just keep clicking next and creating many blank
> > records.
> > Is there any way around this?
> >
> > Private Sub Command116_Click()
> > On Error GoTo Err_Command116_Click
> >
> >
> > DoCmd.GoToRecord , , acNext
> >
> > Exit_Command116_Click:
> > Exit Sub
> >
> > Err_Command116_Click:
> > MsgBox Err.Description
> > Resume Exit_Command116_Click
> >
> > End Sub
>
>