Hi all,
I'm sure this has definetly been asked before, however I'm struggling to find an answer that I fully understand and can incorporate into my own system. So apologies in advance if this is a duplicate or similar to other threads.
I have multiple forms on my system, some create new records, others update existing records, so on and so forth. These are all 'bound' forms.
After research i believe i understand the theory of .dirty records however I have no clue how to implement it.
I require a form to only write the data to the table / query if a save button is clicked. Any other action (Closing the form, switching to another record, etc) then dumps the data inputted.
My table also uses some Autonumbering as ID's, It is important for me to retain this function (As for bound forms).
I undertstand i will have to implement any solution onto all forms, thats not a major issue as I've spent enough time slowly developing the system and adapting it over the last few weeks. I'm not too clued up on SQL anymore, so i really would need that explained in a step by step process if proposed, however this would not be the best of solutions for me.
See attached Zipped version of my system (All items are hidden)... Cardinal HUB.zip