Solved

Running a public form function (via shortcut menu)

Posted on 2016-10-22
2
18 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

932 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now