Hi

I'm writing a visual basic program to automate a series of remote site dial in status checks.

After each site is checked I am writing back the site name and status to a table in an access database.

I want to enable users to print an access report depending on the date they put into a text box on one of my VB forms.

The report takes it's data from a query in the database.

The select query currently goes like this:

SELECT * FROM tblMain WHERE Date =

What do I need to put on the end in order to make the query dependant on the string from my VB project (strCurrentDate)

Any suggestions would be much appreciated.

Best Regards.

Rob Brown