form to display recordset

[finafisken]

Howdy!

How do you go about displaying the results from a query (safely tucked away in a recordset) in a form (Access 97)?

The query is dynamic so there is no way of knowing the number of fields or records beforehand.

Thank you all!

/Markus

 

[DougP]

Click the Queries TAB
then highlight your query (single click it)
Next click the "Insert" menu then AutoForm

it will create a fom in a second or so
and thats it DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[finafisken]

Wow! So easy... so much time wasted...

However, in this particular case I've engulfed myself in code so it won't work. I try to force the recordset values into a textbox on a form (which by chance is very similar to the Northwind Quartly orders subform..) but only the very last record is seen. How can I solve this?

Still at a loss

/Markus