I am working with a form that has a table as a Record Source with fields to enter new records only. That same form has the table displayed as a subform as well. This same form will also serve as a display of existing records. How do I prevent a new record being added each time the form is displayed? I would like to be able to save the new record if entered (SAVE Button), but otherwise not save anything if the form is closed.
If I make the fields unbound that I want to be saved when the Saved Button is clicked, how do I add the new record? Sometimes Access is just too automatic. Any design suggestions would be appreciated.
If I make the fields unbound that I want to be saved when the Saved Button is clicked, how do I add the new record? Sometimes Access is just too automatic. Any design suggestions would be appreciated.