How to prevent a subforms query from running straight away?

Dickie Black

Guest

Posts: n/a

27th Aug 2003

Hi,

I have a main form with a number of subforms. The main form has combo boxes
etc that specify criteria for the subforms' queries. How can I prevent the
subforms queries from being run when the main form is loaded? (When no
values for the criteria will be available) I have a command button which
will then refresh the subforms.

Thanks,

Dickie Black

« Can one entry on a form drive another field? | Re: password protect a form »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
prevent user from deleting a tab prevent running macro from menu	joemeshuggah	Microsoft Excel Programming	5	25th Feb 2010 11:58 PM
Straight Line is not straight	klm	Microsoft Excel Misc	2	13th Sep 2007 07:19 PM
straight line graph, really straight line..	=?Utf-8?B?SmFzb24=?=	Microsoft Excel Misc	2	20th Jul 2006 10:08 PM
subforms with several subforms	=?ISO-8859-15?Q?Peter_H=F6ltschi?=	Microsoft Access	1	23rd Mar 2005 12:20 AM
Running VB .NET win form straight from web click	BobAchgill	Microsoft VB .NET	1	27th Jan 2005 03:25 PM