I have a main form that exists out of two subforms. Whenever I click a button, I want all my records in the lower form to be inserted(added) to a table.
The upper form uses that table as part of a query. So after the button is pressed, I need to update the upper form so it also shows the new records (along with the other elements that came from the other table in the query)
After All that is happened, I need my lower form to clear the first table so it shows nothing.
Now what is the current situation?
My upper form shows nothing new untill the form is reloaded (as in closed and reopend). And my lower form shows the files that were deleted, but with the word "#deleted" as value of some elements.
Any ideas?
The upper form uses that table as part of a query. So after the button is pressed, I need to update the upper form so it also shows the new records (along with the other elements that came from the other table in the query)
After All that is happened, I need my lower form to clear the first table so it shows nothing.
Now what is the current situation?
My upper form shows nothing new untill the form is reloaded (as in closed and reopend). And my lower form shows the files that were deleted, but with the word "#deleted" as value of some elements.
Any ideas?
