Triggering Yes/No message box based on date

[ecrespol]

I have a form in my database that opens by default. I want to trigger a yes/no (yes would run a query, no would end) popup based on the value of a field in a table or query (i.e. if "now" is fifteen days past date in the table/query).

Any help would be most appreciated.

-Eric

 

[adevera]

What field you are referring in your table...

 

[ecrespol]

It will be a date field in a one row table ("LAST_UPDATE"), but I don't think it would matter much either way. Also if anyone has a better way of implementing this idea (without using a table) I'm open to suggestions.

-Thanks

 

[Epic]

advera just asked ....

anyway...

On your form use OnOpen event

if (tablefield.value + your comparision period) >= now() then
code...
end if

 

[ecrespol]

Thank you kindly that worked perfectly.