Solved

Running a public form function (via shortcut menu)

Posted on 2016-10-22
2
30 Views
Last Modified: 2016-10-22
I have a Listbox within a form that occasionally needs to give the ability to switch row-source.  I currently have a toggle button on this form that switches it, but having the extra button on the form is ugly (especially since it will hardly be used).  I wanted to add a shortcut menu to this Listbox (easy enough), but I want it to be able to call the function within the form.  Usually, I'd put the function in an external module, but time is against me and it's not essential.

Will it be technically ok to do this (even though I know it's not best-practice)?
0
Comment
Question by:Andy Brown
2 Comments
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 41855128
Not sure what you mean. It is certainly OK - indeed preferred - to put a function specific to form within the code-behind-module of the form rather than in an external module.

/gustav
0
 

Author Closing Comment

by:Andy Brown
ID: 41855129
Oh - for some reason, I thought it was a bad idea......

In that case, I'll get cracking - thanks Gustav (yet again).
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question