?
Solved

Running a public form function (via shortcut menu)

Posted on 2016-10-22
2
Medium Priority
?
51 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 53

Accepted Solution

by:
Gustav Brock earned 2000 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

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

599 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