Prompt for entry after 3 months

[Guest]

Hi all,
I need to have a prompt come up in my database for a new entry.
I need it pop up after three months of the person's leave date.
Any ideas?

Thanks.

 

[Guest]

In your macro named Autoexec have it open a query. Set a condition in the
second action line to check if any records were returned when the query was
opened. If no records close the query.
The query will have an add column like --
X:[Leave Date]+90
Set criteria as --
<=Date()
This uses 90 days after leave date or you can use 3 months like --
XateAdd("m",3,[Leave Date])

 

[Guest]

Hi Karl,
Thanks for your reply.
How would I write the condition?
Also, the propmt I need is to ask the user to enter data in another field
i.e. where are they now.
Does this change what I need to do at all.
Thanks for you help, much appreciated.

In your macro named Autoexec have it open a query. Set a condition in the
second action line to check if any records were returned when the query was
opened. If no records close the query.
The query will have an add column like --
X:[Leave Date]+90
Set criteria as --
<=Date()
This uses 90 days after leave date or you can use 3 months like --
XateAdd("m",3,[Leave Date])

Hi all,
I need to have a prompt come up in my database for a new entry.
I need it pop up after three months of the person's leave date.
Any ideas?

Thanks.