End of recordset navigation default message box

[matnhouse]

I am having troubles in a form, whilst navigating through records shown in a form view, upon coming to the end of the recordset the default macro message box appears telling me its the end of the record set and then a second box appears after asking me to 'halt' the macros actions.

What I would like is to put in a customised message box telling me the end of recordset is nigh but I cannot get into the cod for the macro, I have been told you can and Im sure I have done it before.

Any ideas?

Thanks

 

[Vassago]

Do a search for acLast, that should help you find what you are looking for.