Comparing date field and trigger action when button clicked

[sanjayakalpage]

Dear Friends,

I have a table to store "issues" with fields Issue name(text), target date(date) and status (combo box-active & pending statuses). default status for new issue is active. when clicking a button i want to change the status of every record to "pending" status (combo box value should be pending) if the target date<current date. I am new to access and kindly request your help. Thank u....

[June7]

Could build and run an Access UPDATE query object.

Or in VBA, maybe:

CurrentDb.Execute "UPDATE tablename SET status = 'pending' WHERE [target date]<Date()"

[sanjayakalpage]

It worked.... Thank u