Form blanks when tab or scroll wheel on mouse is used

[Amour]

Hi I am new to Access and I have this problem that occurs when the user
either presses the last tab key or when you turn the scroll wheel on the
mouse. In each case this action causes the form to go blank.

What I want is for this not to happen..

I checked to see if a blank record was written to the table and No there was
none. It just blanks the form (does not write to table).


Where is the problem?

Thank You for any help on this matter

 

[molsonexpert]

It's not 'writing a blank record', it's going to a new record. If you have
navigation buttons turned on, you should see the record increment when you
scroll. There are some utilities out there to disable this (try lebans.com);
I do this with all my apps because for my users it's one of the most
frustrating things going.

hth.

steve.

 

[Amour]

Hi, I was able to fix the problem with the Scroll wheel on the mouse by
changing the default property on the form from: single to: continue. But I
still have the problem with the tab advancing on the form.

 

[yarra]

Try this: instead of setting the Record Source for your form to "MyTable" or
whatever, set it to a query like "SELECT * FROM MyTable WHERE MyPrimaryKey =
1234". You can also set the select criterion from another form if you want,
or even from the same form as long as you use Me.Requery afterwards.

I picked this up from another post on this site which I now can't find, and
it works like a dream! Whoever first suggested it, thanks a million!

 

[yarra]

PS: I forgot, you'll also need to set the "allow additions" property to "no".