Reference a control in a subform from a module

[sponge7]

Hi,

I'm trying to reference a control in a subform from a module but I keep getting errors!

Here's what I've tried.. and what error I've been getting:

First try:
GetCboEntries = Forms.frmMain!frmSub.Form![cboEntries].Column(1)
(where frmSub is the name of the actual form in the subform control)
Error: Object doesn't support this property or method

Second try:
GetCboActivities = Forms.frmMain!chdMain.Form![cboEntries].Column(1)
(where chdMain is the name of the subform control)
Error: Object doesn't support this property or method

Third try:
GetCboEntries=Forms!NameOfMainForm!NameOfSubform![cboEntries].Column(1)
Error: Run-time error '2450':
Microsoft Access can't find the form 'frmMain' referred to in a macro expression or Visual Basic code.

Any help would be much appreciated!

Thanks in advance!

 

[KenReay]

Hi

Forms!frmMain!frmSub.FORM.cboEntries.Column(1)

should do it, but...

frmMain must be open

frmSub must be the name of the subform CONTROL on frmMain (which is not necessarily the same as the subform name)


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK