Macro's giving errors after settings change

[dedjloco]

So I was trying some settings in the Options>Current Database to restrict people from editing the database. But now it seems that part of the macro's don't work anymore. I put back all the settings but still have this problem.
If you have a look at my database when you click the checkboxes on the first tab, other fields should appear but they don't anymore. Before all of this everything worked well.
And it comes up with an error that it can't find the "Scores" form, but it is there.

Hope anyone could have a look.

 

[JHB]

..
And it comes up with an error that it can't find the "Scores" form, but it is there.

The "Scores" form has to be open in Form view.

 

[dedjloco]

oke is there a work around? someting I can do in the code?
if not how can it be open and hidden? because in the and I want a windownwithout ribbon and navigation pane.

 

[JHB]

Put the below code in the form "Product Specs" on load event:

Private Sub Form_Load()
  DoCmd.OpenForm "Scores", acNormal, , , , acHidden
End Sub

 

[dedjloco]

Thank you it works good.
But this bring an other problem. I have this button "change scores", and when I pressed it then the scores form would open as a popup screen. but now this doesn't work anymore.
Probably you can do someting simular to how you hide it, but I think when you close it again you will end up with the same problem or not?

 

[dedjloco]

Maybe an other idea is to change all the references in the macro to the data in the table. but I don't know how I can do that.
So now I try to retrive the data out of alle the fields from the scores form, but all that data is stored in the scores table as well. but how can I call that in my code?

 

[JHB]

You could open the form "Score" as hidden in the start of "Public Sub ScoreMacro()" and close it again in the end of the Sub.

  DoCmd.Close acForm, "Scores"

Remember to delete the code under on load event.