Stop Subform Populating on form load

J

John

Hi there,

I've got a form that contains a number of combo boxes that are used as
filters (criteria) for running a query, which appears as a subform in the
same form.

I've got a command button that requery's the subform, but is there a way
that I can prevent the subform being populated when the original form is
opened? (I'd rather it waited until I've selected the options from the
combos and then clicked the requery button?

Many thanks

John
 
R

Rick Brandt

John said:
Hi there,

I've got a form that contains a number of combo boxes that are used as filters
(criteria) for running a query, which appears as a subform in the same form.

I've got a command button that requery's the subform, but is there a way that
I can prevent the subform being populated when the original form is opened?
(I'd rather it waited until I've selected the options from the combos and then
clicked the requery button?
Click to expand...

Leave the SourceObject property of the subform control blank and apply it
instead of using Requery.
 
J

John

Hi Rick,

Thanks for this. I had a go with your suggestion, but I assume I'm not
doing it in the right way:

Me.sbfrmvNew.SourceObject = "SELECT......

Unfortunately it doesn't want to let me change the property?
 
J

John

Hi Arvin,

Thanks for this and the link. I'm afraid I don't quite understand what this
does? Is it just a blank query to give it something to think about?

John
 
A

Arvin Meyer

It keeps each of the bound controls on the form from reading "#Name"

If you are building the RecordSource with each combobox choice, you must
start with an unbound subform, or one which is empty. This query allows you
to bind to a recordsource which will never have any records, until you make
your choices in the combobox.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
R

Rick Brandt

John said:
Hi Rick,

Thanks for this. I had a go with your suggestion, but I assume I'm
not doing it in the right way:

Me.sbfrmvNew.SourceObject = "SELECT......

Unfortunately it doesn't want to let me change the property?
Click to expand...

The SourceObject is the name of the form being displayed with the subform
control.
 
Top