As the title says, this is probably a silly question for all of you experts:
One of the things that I really dislike about the way access works is the way that it updates in real-time fields in a table that are on a form.
As an example I have : table - query - form , now in said form there will be data that I don't want to be changeable so I have locked these fields in the form (that works fine) but there are other text boxes that can be changed, and some of them have combo drop down boxes that have an effect on other text boxes.
Now this is all fine and dandy, but with this setup as soon as a user changes one of the drop down box values, or changes any other changeable text box, access saves this to the table via the query...
But I don't want this to happen !! I want to have a Save button that then commits the changes to the table, thus also allowing the use of a Cancel and Exit button to allow all changes to be ignored.
I have tried using DoCmd.Close acForm, "FormName", acSaveNo
But this seems to be totally pointless as the changes have already been saved.
Am I missing something really fundamental with working with forms and tables, is there some command that stops the form from saving immediately to the table, or do I have to go about this in a totally different way ?
I have other forms that use unbound text boxes that get their data from the original table and then when I click on the Update button it basically does old value = new value , but this seems like a clunky way of getting round the issue.
Any tips / ideas ? or do I just have to live with "That's the way Access works"
Many thanks
Damob
One of the things that I really dislike about the way access works is the way that it updates in real-time fields in a table that are on a form.
As an example I have : table - query - form , now in said form there will be data that I don't want to be changeable so I have locked these fields in the form (that works fine) but there are other text boxes that can be changed, and some of them have combo drop down boxes that have an effect on other text boxes.
Now this is all fine and dandy, but with this setup as soon as a user changes one of the drop down box values, or changes any other changeable text box, access saves this to the table via the query...
But I don't want this to happen !! I want to have a Save button that then commits the changes to the table, thus also allowing the use of a Cancel and Exit button to allow all changes to be ignored.
I have tried using DoCmd.Close acForm, "FormName", acSaveNo
But this seems to be totally pointless as the changes have already been saved.
Am I missing something really fundamental with working with forms and tables, is there some command that stops the form from saving immediately to the table, or do I have to go about this in a totally different way ?
I have other forms that use unbound text boxes that get their data from the original table and then when I click on the Update button it basically does old value = new value , but this seems like a clunky way of getting round the issue.
Any tips / ideas ? or do I just have to live with "That's the way Access works"
Many thanks
Damob