Visual Basic Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsProgrammingVisual Basic Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
Free Web 2.0 Code Generator! Generate data entry and reporting .NET Web apps in minutes. Quickly create visually stunning, feature-rich apps that are easy to customize and ready to deploy. Download Now!
  #1  
Old July 29th, 2004, 05:30 AM
Paula Paula is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jul 2004
Posts: 65 Paula User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 37 m 32 sec
Reputation Power: 4
Question Load Statement

Does anyone have any ideas on what is wrong with this statement?

Load (Forms![Clinical Audit Report Form].[subform recommendations])

I checked the help and it says 'Load object'. That's all. But when I type the word Load, the quick info that pops up tells me to use round brackets around my object. I have tried the whole thing with and without brackets and nothing works.
I need to load the subform into the memory but not show it, and to do that I have to have the parent form loaded I think, which is why my statement looks the way it does. I've also tried the following combinations and still get roughly the same error (can't find form).

Load Forms![Clinical Audit Report Form].[subform recommendations]
Load (Forms.[Clinical Audit Report Form].[subform recommendations])
Load [subform recommendations]
Load Forms![Clinical Audit Report Form]![subform recommendations]

Any help appreciated, thanks!

Reply With Quote
  #2  
Old July 29th, 2004, 07:34 AM
spak111 spak111 is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jun 2004
Posts: 349 spak111 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 29 m 25 sec
Reputation Power: 5
Send a message via AIM to spak111
By loading the parent form, the subform is automatically loaded, because it only exists when the parent form exists and is part of it. This looks like this is being done through Access, if this is the case, you can actually load the subform explicitly, because each subform has a form name that can be called, but it then won't be attached to the parent form which it looks like you need. What you may want to do, is load the parent form, then hide the subform by changing the visibility property to false. I hope this helps!

Reply With Quote
  #3  
Old July 29th, 2004, 07:50 AM
Paula Paula is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jul 2004
Posts: 65 Paula User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 37 m 32 sec
Reputation Power: 4
Thanks for that. I don't need the parent form loaded but I have tried just loading the subform and it says it can't find the form. However when I try to load just the parent I get the same message. Basically nothing will load. There must be something wrong with the syntax but I just don't know what.

Reply With Quote
  #4  
Old July 30th, 2004, 07:43 AM
spak111 spak111 is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jun 2004
Posts: 349 spak111 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 29 m 25 sec
Reputation Power: 5
Send a message via AIM to spak111
In Access, go to the forms tab, and see what the subform is actually named. From there you should be able to explicitly open it via the form name as its own object. You may actually want to use the DoCmd to open the form:

DoCmd.OpenForm FormName:="subforms recommendations"

I believe that this is the way that you have to use to open a form in Access. I hope that this helps you solve your problem!

Reply With Quote
Reply

Viewing: ASP Free ForumsProgrammingVisual Basic Programming > Load Statement


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway