Date Referance

[Steve1001]

Hi

I want a code to run when the current date passes the date set in a table, I am using the code below

If "date() " > "table.[sample.check]" Then

DoCmd.Quit


End If

where sample.check is the tabel and field with date, what hve i done wrong??

Many thanks

Steve

 

[petermeachem]

For starters
If "date() " > "table.[sample.check]" Then

You have put quotes around the text. This will always return the same result

If date() > table.[sample.check] Then

Secondly, where do you get table.[sample.check] from?

It ought either to be on a form, where the name would be more like [sample.check] (bad form to use .'s in a field name, or spaces). Or it might be from a recordset, in which case the name ought to be like rs("[sample.check]&quot

Peter Meachem
peter@accuflight.com

Support Joanna's Bikeathon

http://www.accuflight.com/blue_peter_bikeathon_2002.htm