Writing a Union Query in VBA

[Bopo]

Hey Guys

I've tried to find an example of this, but sadly I haven't found one, therefore I'm questioning if it's actually possible.

Is it possible to merge the following two queries using a union, if so syntax wise how would you write it?

sqlQuery(0) = "UPDATE TblResource SET New = 'No' WHERE ResourceType = '" & Forms![SFrmSelectResources]![cboresources] & "'"
sqlQuery(1) = "UPDATE TblResourceType SET QuantityRemaning = '" & quantityLeft & "' WHERE ResourceType = '" & Forms![SFrmSelectResources]![cboresourcetype] & "'"

Thanks

 

[ajetrumpet]

i don't think you can use UNION with action queries

 

[georgedwilkinson]

No, it is not possible.