Software

Ask something
Discussion Locked

Access 2000

0 helpful
6 replies

by grcs1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

My releated db is loosing records because it is not consistantly assigning the key field to a releated table. I use form/subform for entry. It works the majority of the time, but fails on an inconsistant basis. Ever seen this before?
Thanks,
Greg

6 replies

by karpi

Hi,

had the same Problem. Narrowed it down to the Wheel of the mouse. It looks like some events don't fire if you use the wheel of the mouse to move to the next/previous record. Had no Problems since the users are limited to keyboard input.

HTH
Karpi

by andydufrane

Had the same mouse wheel issue before. It is very picky as to where your cursor is when you're scrolling with the mouse wheel. Access will also create a new (next) record if you scroll too far etc.
I'd recommend adding a couple of command buttons to your form and having be Next Record, Previous Record, and even a Find Record (uses the Find/Replace text search engine). Those might give an alternative to mouse scrolling.

If the mouse scroll isn't it, can you give a little more info on what isnot showing up for you?
Good luck!

This discussion is closed to new replies.