If it's a relatively simple query, then there's no need to
dump the results to a table. You should be able to access
each record like this:
*****
Dim dbs as DAO.Database
Dim rst as DAO.Recordset
Set dbs = CurrentDb
Set rst = dbs.OpenRecordSet("MyQueryName")
rst.MoveFirst
Do Until rst.EOF
rst.Edit
rst!FieldName = "SomeValue"
(etc)
rst.Update
Loop
rst.Close
Set rst = Nothing
Set dbs = Nothing
*****
If your using ADO instead of DAO then look up the syntax
and the idea is the same.
Quote:
>-----Original Message-----
>I am a novice VB and module user and am having trouble
>accessing the results of a query in a module. If I try to
>access each resulting record of the query in my module by
>using a loop I get 9000 more than are actually there. I
>am not sure how to properly open this query as a
recordset
>in my module(I think thats the problem). I figure I
>should try to write the query results out to a table and
>just use the table but am unsure how to do that. thanks,
>.
query to table