View or query a recordset

[jonomac]

How can I show the results of a recordset in the same way as you would see if you'd run a select query?

eg in my mind it would appear similar to this in code:

docmd.openquery rst acviewnormal

Thanks, jono

 

[freakazeud]

Hi,
base a form on the query and display the results there. Your users shouldn't really see the query itself rather then just the information displayed the way you want them to see it on a form. Then either requery the form after you run the query to reflect the changes (if the form is open all the time) or open the form after you run the query to display your results.
HTH
Good luck

 

[jonomac]

Thanks for the quick reply.

I guess this will have to be done in this manner, I was aiming to avoid it, altho it wouldn't require much effort to code I guess.

I also recieved this reply in another forum I use which I will check out tomorrow morning when I return to the office.
http://www.dbforums.com/t1175735.html

Cheers, jono

 

[freakazeud]

You're welcome.
Glad I could assist.
Good luck on future projects!