Samantha
still learning...
- Local time
- Today, 18:14
- Joined
- Jul 12, 2012
- Messages
- 187
Hi all,
I have created a modal form with a combo box that the user can select the ServiceAddress and the report will open. This does work how I intended. My question is how do I make it so if the report is open and the user wants to select another address from the combo box it will refresh with the updated information. As of now you have to close the report before choosing a new address. This is the code that I currently have running.
Private Sub cmdRunReport_Click()
DoCmd.OpenReport "rptJobsByServiceAddress", acViewPreview
End Sub
Any help is greatly appreciated!
Samantha
I have created a modal form with a combo box that the user can select the ServiceAddress and the report will open. This does work how I intended. My question is how do I make it so if the report is open and the user wants to select another address from the combo box it will refresh with the updated information. As of now you have to close the report before choosing a new address. This is the code that I currently have running.
Private Sub cmdRunReport_Click()
DoCmd.OpenReport "rptJobsByServiceAddress", acViewPreview
End Sub
Any help is greatly appreciated!
Samantha
