Solved

Running a public form function (via shortcut menu)

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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

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…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

743 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

10 Experts available now in Live!

Get 1:1 Help Now