Use a variable as the "Select * From" source!

[gangel]

Hey ppl,



So i want to write this:

Set IRS = CurrentDb.OpenRecordset("Select * FROM " & QuDiv & " WHERE [deactivate] = false and [ManualInvoicing] = false", dbOpenDynaset)

SO i want to set QuDiv but i dont know what to save it as.

I tried
Dim QuDiv as object

Set QuDiv = "QuPriceRptDiv1"

and it came up as object error.

Ideas?

[CJ_London]

QuDiv should be a string

[ranman256]

I dim everything as variant. (No dim needed for that)

[gangel]

awesome thanks!

[InsuranceGuy]

I dim everything as variant. (No dim needed for that)

No man, just no.

http://www.cpearson.com/excel/declaringvariables.aspx
https://msdn.microsoft.com/en-us/lib...(v=vs.60).aspx
http://spreadsheetsuperstar.com/vba-variant-data-type/

Reconsider, please.

Jeff