SQL, VBA + dates :S (RESOLVED)

[Bazzlad]

I have a table called tblproblem.
In this table is a value called [date reported]

I have a form called frmtest

on this form is a textbox, text7 which is populated by a figure of 1 -12 (1 being january, 2 being feb etc)

I want my SQL script to bring up all records made in july, or whatever month i choose.

SELECT *FROM tblproblem
WHERE datepart(month, [date reported)] = datepart(month,'forms!frmtest!text7.value');

Something like that. But that doesn't work.

HELP!!!!