Protocol Q for vba

[Newby]

I am try to embed a query into an Access code. I copied the sql statement of a query and pasted it into my code for a button in another form expecting it to run. No luck. See code below. Also, I notice code tables.Tablename.tablefieldname and Table!Tablename!Tablefieldname. what is the difference between using the "!" or "." as a separator?

SELECT to_dos.ID, to_dos.Task, to_dos.[Task Desc], to_dos.Interval, to_dos.Day, to_dos.DOM, to_dos.Distribution, to_dos.Minutes, to_dos.DateCompleted, to_dos.[Report Type], to_dos.[Report Location], to_dos.[Source Link], to_dos.[Other Source], to_dos.[Destination Link], to_dos.[Other Destination], to_dos.[Documentation Tab], to_dos.Instructions
FROM to_dos


WHERE (((to_dos.Interval)=[forms].[f_RptgSched].[CBx_Interval]));

[orange]

There are many tutorials related to SQL and vba at Martin Green's site
http://www.fontstuff.com/

What is protocol Q??

Google MsAccess dot vs bang

[Newby]

The code does not work. Do you have an example of a sql query in vba. The reason I what it in code is that eventual I want to attached variables.

newby

[orange]

Yes, see martin green's site
Here is a specific tutorial
http://www.fontstuff.com/access/acctut15.htm