simple question...

[C L Humphreys]

Hi,

I've managed to create a string SQL query taken from a series of comboboxes,
tickboxes and textboxes, this is created when an actionbutton is pressed.

The question is, how can I display this query? I've looked at doCmd.runSQL
but this doesn't work with select queries. I can create a recordset, but
after this I am unsure of where to go, and what to do with it!

Thanks in advance,
Chris

[Pieter Linden]

Re: simple question...

"C L Humphreys" <clhumphreys@to ofgib.moc> wrote in message news:<bkchjs$hh h$1@ucsnew1.ncl .ac.uk>...[color=blue]
> Hi,
>
> I've managed to create a string SQL query taken from a series of comboboxes,
> tickboxes and textboxes, this is created when an actionbutton is pressed.
>
> The question is, how can I display this query? I've looked at doCmd.runSQL
> but this doesn't work with select queries. I can create a recordset, but
> after this I am unsure of where to go, and what to do with it!
>
> Thanks in advance,
> Chris[/color]

open a recordset based on the query and then assign that recordset to
be the rowsource of a data control?