Hello all,
I think the title of the thread sais it all. I need to run a make table query every time the user opens a specific form, or clicks on the "Refresh" button, to requery it. I have searched the net for 20 minutes, and can't find the answer.
The background:
The make query updates the values in one of the source tables of that form. I can't include the query itself in the record source, becouse than the fuelds would not be updateable. I also need to set a primary key for that table after recreating it, but that is no problem. The only problem is that I can't find a Form event, from which I could reasonably update the record source of the form itself.
Thanks for the suggestions!
I think the title of the thread sais it all. I need to run a make table query every time the user opens a specific form, or clicks on the "Refresh" button, to requery it. I have searched the net for 20 minutes, and can't find the answer.
The background:
The make query updates the values in one of the source tables of that form. I can't include the query itself in the record source, becouse than the fuelds would not be updateable. I also need to set a primary key for that table after recreating it, but that is no problem. The only problem is that I can't find a Form event, from which I could reasonably update the record source of the form itself.
Thanks for the suggestions!