How do I make my last record not say autonumber?

[James mckillop]

I am trying to find a line in VB that will let me detect
when my record number says (autonumber) to automatically
goto Previous_record_click, but EOF Is not reconized and

IF Form_KittenMain!RecordNumber = "(AutoNumber)" Then
Previous_Record click
end IF

Does not work either.
Any sugestions this is using access 2000 by the way.

James

 

[John Crighton]

James,

I think you might want to use Me.NewRecord instead.

John C.

 

[Kelvin]

It sounds like you are trying to prevent the form from going to a new
record. If so, just set the AllowAdditions property of the form to No.

Kelvin

 

[James Mckillop]

If I do that then my Add new record button will not
work. I want to be able to use the next record button
and the previous record button to go through all the
forms with out having it acidentally create four or five
new records.

Any other sugestions?

 

[Kelvin]

In your add new record button, turn AllowAdditions back on before the rest
of the code. Then on your save or cancel button or what ever you have to
indicate that the record is finished, turn it back off.

Kelvin