Problem navigating beyong the last record

J

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
 
E

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
 
J

Jack

Thanks ErezM for your help. It worked perfect.

ErezM via AccessMonster.com said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top