menubars

[maxmangion]

i have some forms, which i am creating customised menubar for them. On each menubar, i am planning to have options such as Add New Records, Delete, Exit Form etc. Now if i will create some general functions in a Module for each of the above, for example :

Function Add_Record()
DoCmd.GoToRecord , , acNewRec
End Function

and then place the function name on the onAction of a command button in the Menubar, will this be ok i.e. will it affect only the current form which has the focus (in case there are other forms opened will they be affected too?)

Moreover is it possible to set a background colour to a customised menubar, because i've seen it on a database, but i do not know how to do it.

Thank You for any advice/suggestions.

 

[MaximusArcher]

The functionality you describe is better suited to a class module.
Put all general functionality into a class, then set the indivdiual properties within the class.

For example you could have a property that could be set to reference the form in question.

 

[maxmangion]

Basically what i would like to know if that general code

DoCmd.GoToRecord , , acNewRec

when clicked from a menubar, would create a record just to the opened form that has the focus, or if it will create a record to all opened forms.

Thanks