Problem navigating beyong the last record

[Jack]

Hi,
I have the following situation. My form accesses a joined query to sql
server linked table. Now when I am going past the last record I am getting an
odbc

error that shows that null value cannot be inserted to field in sql server.
Is there any way to prevent navigation beyond last valid data with some kind
of message. I appreciate any help here

 

[ErezM via AccessMonster.com]

hi
setting the form's AllowAdditions property to false prevents the user from
gliding/moving past the last record (into the new record)

good luck
Erez

 

[Jack]

Thanks ErezM for your help. It worked perfect.

hi
setting the form's AllowAdditions property to false prevents the user from
gliding/moving past the last record (into the new record)

good luck
Erez