Good Afternoon
I think this belongs in the Query Forum.
My database displays a form on which I enter details and create a new record. There is a button which when clicked runs a query and opens another form which displays the information entered on the first form.
The system works but in order to display the information on the second form I have to enter the information on the first form, close it then open it again to rerun the query prior to clicking the button to display the information on the second form.
Is there a command I can put in the first form On Close Event or the Button Click Event to rerun the query prior to the second form opening?
Thanks
Tyler
I think this belongs in the Query Forum.
My database displays a form on which I enter details and create a new record. There is a button which when clicked runs a query and opens another form which displays the information entered on the first form.
The system works but in order to display the information on the second form I have to enter the information on the first form, close it then open it again to rerun the query prior to clicking the button to display the information on the second form.
Is there a command I can put in the first form On Close Event or the Button Click Event to rerun the query prior to the second form opening?
Thanks
Tyler