Need help with creating a drop down menu. I am trying to replicate the
GUI of a large db application that runs on large Sun servers using
Oracle/Solaris, etc. My purpose is to create a stand-alone training
package using Access that people can run on a laptop to simulate as
near as possible the GUI of the real system.
My problem is that the actual application has a number of forms in
datasheet format which have a the word "File" in the form header. On
clicking "file" you then get a drop down menu with New (open New data
entry form), Open (open Edit form for selected row in datasheet),
Delete (delete selected row in datasheet), Cancel, plus other options
specific to the relevant form.
I have created the various forms and then added sub-forms in datasheet
format. My problem now is to create the drop down menu. I don't want
to use a Menu bar as this would not replicate the actual application.
I can't see how I can get a Command button to do the job.
My VBA knowledge is nil.
Looking at past group messages I haven't seen a solution, so any help
appreciated.