Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Clear Subform on Load

Posted on 2014-04-17
6
Medium Priority
?
1,187 Views
Last Modified: 2014-04-26
I have a subform in Access that I would like to have clear when the main form is opened.

The subform is based on a query that uses options chosen in the main form.

Right now the subform contains every record when it opens, rather than waiting on the items to be chosen in the main form.
0
Comment
Question by:Megin
6 Comments
 
LVL 58
ID: 40007650
You can set it DataEntry property to true by default, clear it's recordsource and set it later, give it a default filter of 1=0 (which is never true and returns no records), or use a control (hidden) as the master value, which you clear and set on your own.

Jim.
0
 
LVL 49

Expert Comment

by:Dale Fye
ID: 40007653
I generally just delete the subform controls SourceObject property, and hide the subform during form load.

Then, after the form is loaded, I will set the SourceObject and make it visible.  You could do the same thing with your main form.
0
 
LVL 85
ID: 40008752
To add to what the others have written:

If your subform object is bound (i.e. has a Recordsource), then Access will always try to fill it with data. In the case of subforms, it will try to fill it with data related to the current record in the main form (assuming you've set the Master and Child properties, of course).

The only way to not show that data is to "fool" Access into either thinking it has no recordsource, or that it's not linked to anything - hence the reasoning behind the suggestions above.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:Megin
ID: 40008912
Thank you, everyone. I will be trying these out later today.
I just didn't want you all to think I was ignoring you.
0
 

Accepted Solution

by:
Megin earned 0 total points
ID: 40013678
I am sorry to take so long to get back to everyone.

None of the solutions really worked for me, but I adjusted the query that filled the sub form and that ended up working.

Thank you for your time and suggestions!
0
 

Author Closing Comment

by:Megin
ID: 40024355
I changed the query in the background to match up with more fields in the main form. This ended up doing what I needed it to do.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question