How do I write this SQL stat in VBA?

[erick-flores]

hello all can somebody tell me how to write this SQL code in VBA

SELECT Employees.EmployeeID, Employees.DepartmentName,
Employees.EmployeeNumber, Employees.FirstName, Employees.LastName,
Employees.[Auto Year], Employees.[Auto Condition], Employees.[Auto
Make], Employees.UsernameHold, Employees.[Location/Division],
Employees.UserGroupName
FROM Employees
WHERE (((Employees.UserGroupName)="Ind Prod Users"));

Also is there a way to execute a query already built in the
Me.RecordSource of the form. In other words dont write the entire SQL
statement just call the query.

Thanks

 

[erick-flores]

Got it

http://www.kirsol.com/qryshuttle.php

Very nice tool