MattBaldry
Self Taught, Learn from the Forums
- Local time
- Today, 10:04
- Joined
- Feb 5, 2019
- Messages
- 293
I have tried many different methods and cannot find one that suits my database structure. I am after a solution for the below.
So, I have a main customer list form, from here you can add or edit customers. I click Add, customer form opens in add record state. I add the new record and when I click close I would like the customer list form to requery the listbox to show the added customer in the list. At the moment I have it as part of the close button. It checks to see if the customer list form is active and the does the requery event.
Is there any method of putting this in the form code such as form activate or something so each time that, or another form, becomes active it does the requery event on the list boxes?
I have also tried adding a code that checks to see if a form is open, and if it does it requeries all the list boxes, but if I have mutliple forms opens it requeries them all.
I want to find a way to only requery the form that has just become re-active. So, something like below.
frmCustomerList > Click Add
frmCustomerOverview > Opens > Enter Data > Click Close
frmCustomerList > Becomes Active > List Box Requery
Does this make sense?
~Matt
So, I have a main customer list form, from here you can add or edit customers. I click Add, customer form opens in add record state. I add the new record and when I click close I would like the customer list form to requery the listbox to show the added customer in the list. At the moment I have it as part of the close button. It checks to see if the customer list form is active and the does the requery event.
Is there any method of putting this in the form code such as form activate or something so each time that, or another form, becomes active it does the requery event on the list boxes?
I have also tried adding a code that checks to see if a form is open, and if it does it requeries all the list boxes, but if I have mutliple forms opens it requeries them all.
I want to find a way to only requery the form that has just become re-active. So, something like below.
frmCustomerList > Click Add
frmCustomerOverview > Opens > Enter Data > Click Close
frmCustomerList > Becomes Active > List Box Requery
Does this make sense?
~Matt