Forgetful Users - A solution anyone? (1 Viewer)

[Mark-BES]

Good afternoon all,

I have a A97 Db. On one of my forms (see attached screen pic) I have a field "Payment type" for either Cheque, card of Account. There is no code or functions behind it, it just stores a value.

Trouble is my users keep forgetting to fill it in!

My first (and easiest) solution would be to make "Payment type" a required field. However. The field will only be filled out under certian conditions.
That is if the "Status" field value = "X" (drop down box holding two values "X" and "Y").

What would the code be? I presume it would be in the Form "after update" field? Would read somthing like:

if [Status] = "X"
and
if [PaymentType] = "Null"
then
mssg box "Please enter payment type"

I have a vba book on order to start learning, but as you have probably guessed, I have not received it yet!

Any pointers or info would be much appriciated. Many thanks

 

[Mile-O]

Use the form's BeforeUpdate event to check the status and if the criteria is met, insist on a value being entered. If there's no value then use Cancel = True and display a message regarding why.