Hi,
I have a form that has a project table as its control (key = project #). There is a table within the form tied to the products table (key = product #). The table's "project #" column is linked to the forms primary key (project #).
Upon exiting the form, or even when switching to design view, I get a prompt which asks me if I want to save changes to the table, even if no changes were made.
Whether I choose yes or no, I still get the same prompt everytime, and as far as I can see, the table has no changed.
I suspect the reason for this is because the "on load" event for the form is to disable the table. It can later be enabled by some other actions within the form.
Is there any way to get rid of this prompt? Is there a different way to structure what I want to do that would avoid this problem.
It's annoying, but also I want to use it as a run time application, and this prompt will not make any sense to anyone else using it.
Any help will be appreciated, thanks.
I have a form that has a project table as its control (key = project #). There is a table within the form tied to the products table (key = product #). The table's "project #" column is linked to the forms primary key (project #).
Upon exiting the form, or even when switching to design view, I get a prompt which asks me if I want to save changes to the table, even if no changes were made.
Whether I choose yes or no, I still get the same prompt everytime, and as far as I can see, the table has no changed.
I suspect the reason for this is because the "on load" event for the form is to disable the table. It can later be enabled by some other actions within the form.
Is there any way to get rid of this prompt? Is there a different way to structure what I want to do that would avoid this problem.
It's annoying, but also I want to use it as a run time application, and this prompt will not make any sense to anyone else using it.
Any help will be appreciated, thanks.