Run Time Error 424: Object Required

[ECEstudent]

Hi, I would appreciate any help I can get on this...I keep getting this error:

Run-time error '424': Object Required

And it keeps highlighting this part of my code:

Set rst = ("INSERT INTO ResultsTable(Structure1, OrderNumber1, ItemNumber1) SELECT (Structure, OrderNumber, Item) FROM CalculateTotal WHERE [Structure]= '" & u & "'")

I'm trying to take the results from query 'CalculateTotal' into table 'ResultsTable'

any ideas? thanks a lot.

 

[JHB]

For using a Recodset you need to have a database object in front of it + OpenRecordset like so:

Set rst = CurrentDb.OpenRecordset("Select ...")

Look in the Help-file for Recordset, or search the Internet.
But you can't use a Recordset for a Action query like you are showing here.
A Recordset is only to use when results are returned.
From the Help-file

An action query changes data or copies data. Action queries include append, delete, make-table, and update queries. In contrast, a select query doesn't copy or change data; it simply returns a set of records.

So to run your query:

CurrentDb.Execute("INSERT INTO ResultsTable(Structure1, OrderNumber1, ItemNumber1) SELECT (Structure, OrderNumber, Item) FROM CalculateTotal WHERE [Structure]= '" & u & "'")