Hi,
I've one annoying thing that happens every know and then.
I've added a navigation form (An Access standard one) where I've included all forms in different category tabs. Some forms add new records in a table while others just update existing records with an additional data.
It's when I move in the navigation form from a form meant to add new records (no data has been entered yet) to another form that a new record is added. This is not the result I want. Since no data has actually been added, I don't want any new record to be created. (As soon as new information has been added I use data validation to secure that all necessary data is added before you can close the form).
Does anyone have any idea how to solve this? I'm about to use a closing event and write some code in order to erase the new record, but there might be an easier solution? If code is necessary - any smart ideas how to solve it?
Rgds,
HHAG
I've one annoying thing that happens every know and then.
I've added a navigation form (An Access standard one) where I've included all forms in different category tabs. Some forms add new records in a table while others just update existing records with an additional data.
It's when I move in the navigation form from a form meant to add new records (no data has been entered yet) to another form that a new record is added. This is not the result I want. Since no data has actually been added, I don't want any new record to be created. (As soon as new information has been added I use data validation to secure that all necessary data is added before you can close the form).
Does anyone have any idea how to solve this? I'm about to use a closing event and write some code in order to erase the new record, but there might be an easier solution? If code is necessary - any smart ideas how to solve it?
Rgds,
HHAG