multiple switchboards

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how can I set up a subform to be only visible on a certain switchboard?

e.g. subform "subfrm-last_update" to be only visible when the "Update"
switchboard is open
 
If I understand your question correctly, you could use something like this,
maybe in the Load event of the form on which the subform is located:

If CurrentProject.AllForms("frmUpdate").IsLoaded Then
Me.SubformControlName.Visible = True
Else
Me.SubformControlName.Visible = False
End If
 
just for further information
the main switchboard has a control to switch to the updating switchboard
(like a sub switchboard) which is where I want the subform to be displayed
Any further help you could provide would be great!
 
The principle is the same in any case. If the subform is on another form,
use the full reference to it:
Forms!FormName!SubformControlName.Visible = True
If that doesn't answer the question you will need to explain just what you
mean by "the main switchboard has a control to switch to the updating
switchboard". If you mean there is a command button or some such that sets
the focus to the other form, be clear on the point.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form References 2
Access Switchboard error message 1
Switchboard Minimized 4
SWITCHBOARD 1
switchboard problem 4
Logical statement on a Switchboard 2
Switchboard in Access 2007 1
Switchboard Questions 2

Back
Top