Solved

call sub in another loaded form

Posted on 2013-01-13
2
275 Views
Last Modified: 2013-01-23
I have a piece of code thx to an expert that checks if a form is loaded and then sets its slider control.

I have a sub called setfilter in the other loaded form (frmsmmtmaster). How do i get that sub to run?

If Me.BtnToggleSyncForms = True And CurrentProject.AllForms("FrmSMMTMaster").IsLoaded Then
 Forms!FrmSMMTMaster.Form.Controls.Item("ccslider").Value = Me.CCExportSlider.Value

End If
0
Comment
Question by:PeterBaileyUk
2 Comments
 
LVL 29

Accepted Solution

by:
IrogSinta earned 500 total points
ID: 38773501
Make your procedure public instead of private.
Public Sub setfilter()

Then call it this way:
Call Forms.FrmSMMTMaster.setfilter
0
 

Author Closing Comment

by:PeterBaileyUk
ID: 38813293
apologies for delay I have been unwell.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

911 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

22 Experts available now in Live!

Get 1:1 Help Now