asked on

Clear Subform on Load

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.

Jim Dettman (EE MVE)

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.

Dale Fye

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.

Scott McDaniel (EE MVE )

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.

Megin

ASKER

Thank you, everyone. I will be trying these out later today.
I just didn't want you all to think I was ignoring you.

ASKER CERTIFIED SOLUTION

Megin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Megin

ASKER

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.