Field Validation Rule based on another field

[yako966]

Hello there,



my name is Giacomo and I'm new here. This is my first post actually. Before I post this I spent two days googling around, without success. I also looked for an existing thread here, but I didn't find anything, so please forgive me if I'm duplicating something..

My question is quite simple: In Access 2013, how can I create a Validaton Rule not allowing a field to be populated if another field is left empty?

I'm not a VBA programmer, so I really would like to work with the Field Validation Rule, in the Table Design View.

I tried the following: [Field_Name] Is Not Null

Not working..

Any suggestion?

Thanks a lot for your help. Of course I'm at your disposal in case you need any further information.

[Bob Fitz]

I don't think that can be done at the table level.
I would do that kind of validation in a forms Before Update event.

[yako966]

Many thanks Bob,

I'll see how I can implement that.

[Bob Fitz]

You would need to write a small amount of code in the forms Brfore Update event.
Post back if you need help with that