A2000/2002.

Stupid question, I hope.

I have a form in which I have a combobox, cboPayType and a textbox,
txtCC.

If the cboPayType.Value = "Cash", I don't need a value in txtCC.
Otherwise, I want to require a value. (If you're not paying cash, I
need a check number or a credit card number). I can stop the
Close/Unload event of the form without a problem.

How do I trap the moving from one record to the next? I thought
OnCurrent is after that...

Thanks,
Pieter

On 5 Aug 2003 20:18:31 -0700, pietlinden (AT) hotmail (DOT) com (Pieter Linden)
wrote:

I would write my code in the Form_BeforeUpdate event, and set Cancel
to True if the user has not filled out the form correctly.

-Tom.