Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #8980

Re: Referring to a module in a referenced database

Show all headers | View raw

This bit works

    Dim Frm As Form
    Dim Mdl As Module
    Dim FormName As String

    FormName = MainFormID.Column(0)		‘ From Combo box		
Set Set Frm = Forms(CodeProject.AllForms(FormName).Name)	‘ In Referenced
Database

This bit gives an error “Error 9 Subscript out of range”
    Set Mdl = Frm.Module

If in the immediate window, I print ?frm.HasModule I get a True answer, and
the other properties other than those to do with a module, like width, help
file, OnOpen =[Event Procedure] appear to be there. How do I refer to the
module?

Thanks

Phil

---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Referring to a module in a referenced database "Phil" <phil@stantonfamily.co.uk> - 2014-02-09 23:11 +0000
  Re: Referring to a module in a referenced database "Phil" <phil@stantonfamily.co.uk> - 2014-02-09 23:13 +0000
    Re: Referring to a module in a referenced database "Phil" <phil@stantonfamily.co.uk> - 2014-02-09 23:26 +0000

csiph-web