Validation Rule

[Guest]

Hi,

I have a DB that is about a month old and now is when i discover that the
users will need required fields to be filled out.In one case, a field with an
invoice number must have the user forced to key in the amount in the amount
field. In the second case, the users are fogeting to fill out one field
before proceeding to the next record.Can the validation rules be entered on
the controls of the form for both cases or is there something i need to go
back to the tables for?
Thanks

 

[Rick B]

A required entry is set in the table. A conditional requirement (one field
is required IF another is etered) must be done in the form. Personally, I
do it using code. I think you can put an "if" in the validation rule for a
field, but personally have not tried it.

Rick B

 

[Guest]

Thanks Rick,

Could you give some direction on how to create a required entry in the
field?I want the record not to be entered unless they key in the field.Is
this like a validation rule that a message pops up?
Thanks