Data Validation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nick Bradbury - 31 Oct 2005 13:12 GMT

Hello

I have a form to enable order details to be entered, some products have a
"Standing_Charge", in these cases the "Rental_Period" must also be entered
otherwise the cost is not calculated correctly. How can I alert the user to
enter this value and to ensure that that a value is added if a
"Standing_Charge" is applied.

Thanks

Nick

Reply to this Message

Jeff Boyce - 31 Oct 2005 14:12 GMT

Nick

If you add code to the [Standing_Charge] field's AfterUpdate event, you
could:

1. ensure that a valid value/choice had been made
2. add a message indicating that the [Rental_Period] field must be filled
in
3. set the focus to (?and highlight) the [Rental_Period] field

To ensure that the entire transaction doesn't finish without the above, you
could add code to the form's BeforeUpdate event to check on the
possibilities.

Signature

Regards

Jeff Boyce
<Office/Access MVP>

> Hello
>
[quoted text clipped - 7 lines]
>
> Nick

Reply to this Message

Klatuu - 31 Oct 2005 14:16 GMT

Use the Before Update events of the controls you need to validate. It will
take some VBA to get it done.

> Hello
>
[quoted text clipped - 7 lines]
>
> Nick

Reply to this Message

Nick Bradbury - 01 Nov 2005 00:31 GMT

Problem solved, many thanks. I really must learn VBA

Cheers
Nick

> Hello
>
[quoted text clipped - 7 lines]
>
> Nick

Reply to this Message