[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Clear Subform on Load

Posted on 2014-04-17
6
Medium Priority
?
1,254 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 59
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 

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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
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.
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…
Get the source code for a fully functional Access application shell with several popular security features that Access VBA application developers desire, but find difficult or impossible to figure out how to code. You get the source code for managi…
Suggested Courses

608 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