Command Button on Navigation Form

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.

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!
 
When ever you make a change to the front end and redistribute it you need to re-link it to the back end.
 
The form is sizeable and is not based on any tables. It contains about 15 command buttons all opening other forms and reports. All of the buttons it contains function without going through this process of resetting the form after redistributing. There are no other problems with the linking of tables.
 

Users who are viewing this thread

Back
Top Bottom