Help with code

[cwbviper]

Hi there,
I am looking to write some code which will look at a date in a table. When the current date is 30days before the date stored in the table a form will be displayed showing the corresponding record. I am a complete novice when it comes to writing access code so any help would be much appreciated.

Thanks

 

[HighLightUK]

Why don't you write a query based on your table and specify the data you want retrieving in the criteria part of the date field?

Then you could build your form on your query...

 

[geaker]

DateDiff function works for this very weel. I use it to calculate dates in the past.

Gerald

 

[cwbviper]

Thanks for the help HighLightUK and geaker. Managed to find a solution on UtterAccess and the problem is sorted now, thanks anyway though.