Hi,
This may be so simple that I'll be really embarrassed, but I have looked around. I just don't know. I'm hoping there is an event that is triggered when the user advances thru the recordset. You see, I have a main form (a demographics form) and dozens of forms that the user can launch from buttons on the main form. But I want to close those secondary forms automatically when the user moves on to a different record. I have the code done and it's part of my custom 'add record' button. So new records are handled, but if the user has been working on a specific record, and has several forms open when they are done, I want to automatically close those forms when the user moves to a different existing records.
I just don't know where to put the code.
Thanks,
Taz
This may be so simple that I'll be really embarrassed, but I have looked around. I just don't know. I'm hoping there is an event that is triggered when the user advances thru the recordset. You see, I have a main form (a demographics form) and dozens of forms that the user can launch from buttons on the main form. But I want to close those secondary forms automatically when the user moves on to a different record. I have the code done and it's part of my custom 'add record' button. So new records are handled, but if the user has been working on a specific record, and has several forms open when they are done, I want to automatically close those forms when the user moves to a different existing records.
I just don't know where to put the code.
Thanks,
Taz