Hello Experts,
I have constructed a databse using about 5 or 6 different forms. I would prefer when a user clicks on a button that the current form closes while the selected forms open and when it does it refreshed on opening. What is the best way to do this with VBA?
should it looks something like this?
Private Sub cmdOpenfrmCustomers_Click(
)
DoCmd.Close (this would close the currently opened for)
DoCmd.OpenForm "frmCustomers"
---some kind of refresh command---
end sub
Thanks,
Terry
Start Free Trial
