If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
cascading combo - record count
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! |
#2
|
|||
|
|||
cascading combo - record count
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 "Annette" wrote in message ... 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! |
Thread Tools | |
Display Modes | |
|
|