Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

call sub in another loaded form

Posted on 2013-01-13
2
Medium Priority
?
296 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 29

Accepted Solution

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
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.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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…

636 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