In the project I am working on I have disabled the Record Controls on all form as they always look untidy. In two of the forms it does make sense for the user to 'scroll through' records one at a time. Like in the Rooms form when looking at rooms that a B&B Operator offers, and also when looking at Payments made for a Booking. Thus I do need the Next/Previous/Add functionality but prefer to have my own style '<<', '>>' & Add buttons.
I would like to trap the Next button keypress that moves beyond the number of records in the recordset and goes to a blank (new) record. I want to make users realize that they are Adding a record by forcing them to use the Add button rather than allow them to press Next too many times and thus arrive at a blank record by mistake.
Is there anything that I could add to Next button code that would just keep looking at the last matching record i.e. stay where it is on the last record on the recordset (with filter) rather than throwing a new record.
BTW Don't worry if I don't reply straight away as I am a part-time developer and my day job calls me now.