Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-01-2009, 05:38 AM   #1
Stemdriller
Newly Registered User
 
Join Date: May 2008
Posts: 187
Thanks: 10
Thanked 0 Times in 0 Posts
Stemdriller is on a distinguished road
Unhappy Method or data member not found

Hi

I have a form that has two sub forms. The first subform is not visible until a button is clicked. The second sub form also becomes visible when a button is clicked within the 1st sub form.

I am using Me.frmAddContact.Visible = True

All I get is Compile Error:
Method or data member not found.
It looks like is simply cannot find the subform.

Any ideas?

Stemdriller is offline   Reply With Quote
Old 10-01-2009, 08:02 AM   #2
RuralGuy
AWF VIP
 
RuralGuy's Avatar
 
Join Date: Jul 2005
Location: @ 8300' in the Colorado Rockies
Posts: 13,820
Thanks: 7
Thanked 311 Times in 301 Posts
RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice
Re: Method or data member not found

Are you trying to make the SubForm visible or the SubFormControl?
http://www.mvps.org/access/forms/frm0031.htm
__________________
(RG for short) aka Allan Bunch Previous MS Access MVP acXP, ac07, ac10, ac13 - WinXP Pro, Win7 Pro, Win10 Pro
Please post back to this Forum so all may benefit.
Teaching is not filling a bucket but lighting a fire.
RuralGuy is offline   Reply With Quote
Old 10-02-2009, 03:36 AM   #3
Stemdriller
Newly Registered User
 
Join Date: May 2008
Posts: 187
Thanks: 10
Thanked 0 Times in 0 Posts
Stemdriller is on a distinguished road
Re: Method or data member not found

The subform visible

Main form is called frmAddClub, 1st sub form is frmAddContact, when the contact is input and saved another button is trying to make the 2nd sub form (frmEnquiresViaAddClub) open. Both sub forms sit on the main form (frmAddClub)

Stemdriller is offline   Reply With Quote
Old 10-02-2009, 03:38 AM   #4
Stemdriller
Newly Registered User
 
Join Date: May 2008
Posts: 187
Thanks: 10
Thanked 0 Times in 0 Posts
Stemdriller is on a distinguished road
Re: Method or data member not found

Just cracked it using

Forms!frmAddClub.frmEnquiresViaAddClub.Visible = True

Thanks for pointing me in the right direction.

Stemdriller is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
method or data member not found option Excel 6 11-05-2008 09:10 AM
'Method or data member not found' error gaju_3112 Forms 1 05-04-2008 09:47 PM
method or data member not found sandy6078 Modules & VBA 7 04-11-2008 04:53 AM
Method or Data Member not found error CarlyS Reports 21 10-03-2006 04:08 AM
Using FindFast with SQL Table? jonno99 Modules & VBA 2 07-08-2005 01:31 PM




All times are GMT -8. The time now is 10:51 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World