Samantha
still learning...
- Local time
- Today, 14:42
- Joined
- Jul 12, 2012
- Messages
- 182
I have split my database into a front end and a backend (access 2010). I am using a Navigation form with a button in the header that opens another form, a menu, that is loaded with buttons for reports and other tasks. Every time I update the front end and redistribute to the users the button opening the menu does not work. To get it working I first have to open the form in design view, switch it to form view then save. This is becoming a pain having to go and do this for each user. Everything else operates just fine. The code on the navigation form is as follows, I generated it from the macro builder.
Any help is greatly appreciated!
Code:
Private Sub cmdLaunchReports_Click()
On Error GoTo cmdLaunchReports_Click_Err
DoCmd.OpenForm "frmReports", acNormal, "", "", , acNormal
cmdLaunchReports_Click_Exit:
Exit Sub
cmdLaunchReports_Click_Err:
MsgBox Error$
Resume cmdLaunchReports_Click_Exit
End Sub
Any help is greatly appreciated!