I call a new record through a macro - open form add.
while inputing in the record, a user can it the rollerball on the mouse and it moves to a new record, and if they don't pay attention, they will add on that too. you can only page back and forth on these two records.
the other delima - is i can open the same form passing the id with a filter to edit and it does the exact same thing, will roll only to the next record,

any suggestions.

sj

sj,
I had the same problem and another Forum Member pointed me to a utility you can install. Here is the link to his reply to my same situation: http://p2p.wrox.com/topic.asp?TOPIC_ID=21346.

I assume you are working with an .mdb. This has worked fairly well for us on most of our forms- except for one, and the solution to making it work on that one is beyond me. Maybe it'll me a 100% solution for you. (assuming your users aren't in favor of scotch taping their mousewheels!:)

Loralee

Loralee

great reply, i did do this which seems to help.
after a tab out, i had a field I set value to , save record, then set additons to no, all in a macro after exiting the first field.
so that fixed it, but thanks. I will try your link.
i think i like the scotch tape thou.
appreciate the time to answer.
take care
Tally Ho.
sj

sj