cascading combo - record count

[Annette]

I have a form that I would like to use somewhat of a cascading combo.

The user will enter a transaction date and based upon the year of the
of date, the next field, rate combo will filter which rate should be
applied. This is working fine until the user enters a date where there
is no rate in the rate table. I would like a message to appear or
something to alert the user that there is no rate for that period of
time. Would this be best at the time they are in the rate field or as
soon as they finish entering the date?

How would I go about checking that there are no maching records in the
rate table.

Thank you!

 

[Jeff Boyce]

Annette

Here's another approach to consider ...

If you let the user enter an invalid date (i.e., one for which you have no
rate info), you have to handle the fact that you have no rate info.

On the other hand, if you prevent the user from entering/selecting invalid
dates, you never have to deal with the missing rate info.

You could use either a validation rule for the date control, or you could
use the BeforeUpdate event on that control to better manage the message the
user sees.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP