Simple Required Field Toggle

[BigBertie]

I'm wanting Field2 (number) to be required only if Field1 (Yes/No) is set to Yes.

Is there a simple way to do this? I went down the road of using an IIF function in the validation rule of Field2, but this didn't seem to work.

TIA

 

[Trevor G]

I'm wanting Field2 (number) to be required only if Field1 (Yes/No) is set to Yes.

Is there a simple way to do this? I went down the road of using an IIF function in the validation rule of Field2, but this didn't seem to work.

TIA

Welcome to the Forum,

Can you be a little more specific. Which version of Access are you using. The only version you can have calculations in a design of your table is 2010.

You could use a form to validate and set certain parameters/conditions.

 

[BigBertie]

Apologies. I'm using Access 2007.

So the validation would need to be on the form, rather than in the table?

I'm pretty new to Access so was planning to get the db structure up and running before I started on designing forms/switchboards etc. Is that a logical way to work?

 

[Trevor G]

No need to apologise, most people miss adding the version so you end up asking otherwise you send people in the wrong direction to find things.

I would create the tables and if there are a few things I need to do which can't be easily achieved in the table, like certain validations, I would use a form as I can set my triggers and code.

Users will find forms easier to deal with and that then safe guards your back end.

Everyone will have an opion, and you will discover a way that works for you. The forum will help when needed and if the stars of the show are around at the time you need help or guidance or simply asking questions, then some really good advice can help you move on.