Running a formula in a macro.

[genericjanedoe]

Hi

I need to be able to get Approach to switch to a report from the main form if certain records are holding a particular type of criteria.

For example, I need to alert users that certain records have passed deadline dates for publications (where a deadline date exists - it doesn't always) and where those dates have not been verified (in a separate field) as having been met.

So far I have been able to make it find dates that have passed the deadline and have not been verified by using the following formula:

Text Deadline Date < Today() and IsBlank(Deadline Met?)

For the life of me, I cannot seem to get it to ensure that there is actually text in the "Text Deadline Date" field first! Consequently, I am pulling up every record where this field has not even been filled in.

To complicate matters, I need to repeat this formula for a couple of other deadline dates within the same macro.

And I have to use "run" within the macro because the "find" does not give me the option of continuing within the current macro if it doesn't find the records.

Can anyone help? Many thanks.

 

[suesloan]

>>For the life of me, I cannot seem to get it to ensure that there is actually text in the "Text Deadline Date" field first! Consequently, I am pulling up every record where this field has not even been filled in.<<

Just test "Text Deadline Date" <> '' where the '' is two single quotes with no space between them.

And a "Named Find/Sort" gives you options on what to do if no records are found. Pre-define your Finds and refer to them in macro FIND commands.

Sue Sloan
XpertSS.com