Loading a form triggers Query

[clcole]

I'm trying to create a master form that links to my other forms, when I click the button to set focus on one of my other forms it runs the query to populate my listbox. Its a listbox thats bound to a query but I don't want it to run, is there anyway to get it to NOT populate the list?

It doesn't try to run when I open that form directly only when I use SetFocus on my master form, why is it doing this and is there anyway to stop it?

[Rabbit]

Where is this listbox located and what's the code behind the button?

[clcole]

ok I have two forms

frmMaster

frmAdd

frmMaster has a button cmdAdd that has the following code

Private Sub cmdAdd_Click()
Form_frmAdd.SetFocus
End Sub

the listbox itself is on frmAdd and seems to want to populate as soon as that form gets the focus.

[Rabbit]

ok I have two forms

frmMaster

frmAdd

frmMaster has a button cmdAdd that has the following code

Private Sub cmdAdd_Click()
Form_frmAdd.SetFocus
End Sub

the listbox itself is on frmAdd and seems to want to populate as soon as that form gets the focus.

Why is it a problem if it runs the query to populate?

I suppose you could set it's row source to an empty string and then set it back when you actually want it to populate.

[clcole]

The query actually pulls data from a combobox in the same form, its usually the afterupdate of that box that triggers the query. That being said to populate this list requires something entered into that combobox and since the form has just loaded there's nothing there and it pops up a dialog box asking for the contents of the combobox.

[Rabbit]

Then just set the row source to nothing until you need it.

[NeoPa]

As he says, don't design the query into the control itself. Simply update the RecordSource of the control in the event procedures that trigger it being required. EG. The AfterUpdate event of the ComboBox that it depends on.

Let us know how you get on :)