Conditional navigation amoung records

[printingfool]

I have a subform which user can enter an invoice number an a check digit for the invoice. There is also a hidden control which calculates the check digit based on the invoice number. I am validating the user's entry of invoice number and check digit. If the invoice/check digit combination entered by user is not valid, then I have message box which notifies user of error and takes the cursor to invoice number control. This works fine except when the user uses the up or down arrow keys. It returns to the invoice number control for either the record above or below (depending on which arrow key).

What I would like to do is have it return to the invoice number control of the record which produced the error. I know some how I need to keep track of the current record and when an invalid entry occurs, then I have a reference of which record caused the problem.

Any suggestions would be appreciated!

Ron

 

[mph1]

I think you might want to disable the Page Up and Page Down keys. Look at the following on how to do.

http://www.mvps.org/access/forms/frm0016.htm

If you have a mouse wheele, you may also want to disable that. Check the FAQ section.


HTH

An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description - FAQ702-5106