Form -> Query (1 Viewer)

[MattyJacks]

Is it possible to create a query from a form? If so, how??

 

[spikepl]

What do you want to accomplish?

Your question makes no sense: a query is a tool to extract/combine data from tables, and a form is a tool to display a recordset, irrespective of how it was originally extracted.

 

[DCrake]

Depending on what your form is doing, ie creating an sql string by some method or another you can replace the sql statement of a query using the QueryDefs collection. Is that what you are thinking about?

 

[MattyJacks]

spikepl - Yeah, make a query using fields from a form.

DClarke - That makes absolutely no sense to me. I don't know that much about databases could you put this into simple english please.

 

[spikepl]

What is this query supposed to do, and what is its relation to the form that you apparently already have?

 

[DCrake]

Perhaps if you were to elaborate on your intentions then the mode of response would be more in fitting with the possible outcome.