Stay on Current Record (Access 2003 SP1)

Topic

New Reply

I’m trying to figure out how to prevent a user from moving to the previous/next/first/last record after a command button click on a form. I’ve disable the navigation buttons, but users who roll there mouse wheel up/down or use page_up/page_down, can still move to another record. I was thinking I could use the wheel_up/wheel_down/Key Press events to prevent this, but that may cause some problems later on. Any suggestions on a more simple solution would be appreciated.

Reply | Quote

Replies

I would filter the form so that there is only one record.

Reply | Quote

Then i will just have to prevent them from clearing the filter. Correct?

Reply | Quote

Thank HansV, I was making it harder than it needed to be. Much thanks.

Reply | Quote