Run a query but do not show it

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel - 07 May 2007 16:32 GMT

Hi,

Is there a way to run a query from a form, but not actually show the
results? All I really want is the information that results from the query.

Reply to this Message

Maurice - 07 May 2007 18:18 GMT

Well you could try activating the query when opening the form. But What kind
of query would you like to run - an action query or a select query because
with a selectquery what is it you would like to see then...

Maurice

> Hi,
>
> Is there a way to run a query from a form, but not actually show the
> results? All I really want is the information that results from the query.

Reply to this Message

John W. Vinson - 07 May 2007 20:47 GMT

>Is there a way to run a query from a form, but not actually show the
>results? All I really want is the information that results from the query.

It's almost never necessary to "run" a Select query (unless you're debugging
it and need to see the datasheet). What "results" do you want to see? A single
value? a single row's values? a whole grid?

John W. Vinson [MVP]

Reply to this Message