Data validation problems

[Auriga]

Help please. We think this is probably very easy but is defeating us.

We have followed the advice on the board to prevent saving a record with a blank field using the validation rule <>" ". This works beautifully when we have a rule for only one field.
However, we have 3 fields we need to protect in this way. Why does it not work for the other two fields?

We also have a series of radio buttons. We need to ensure that at least one is selected before saving but are a bit stumped on how to do this.

Many thanks to you all once again

 

[Norie]

You need to set validation for all the fields.

 

[Marbles]

Could you set the Required Tab to Yes?

 

[Auriga]

Thanks for all your help!

Hello to everyone who has been helping us with our problems. We are really pleased to be able to say that we have sorted ourselves out and we are proud of the results. So thanks to you all for the suggestions we have used, and for the suggestions that made us think about things differently so we managed to work out a solution for ourselves.

The validation rules were not working properly when applied to all the individual fields. They worked fine when there was only one rule on the form, but for some reason when we had three set up it only followed the first one. We have got round this by adapting some code posted by Corticus back in 2003 - many thanks for that too - that goes in the code on the save button.

We have also sorted out the data entry only problem by having the form set to add new record, and then hiding the navigation buttons at the bottom of the screen so that only the current record shows for the user. We know this is not foolproof, but it is definitely enough to fool the users we have!

Once again thanks for the help, it is very much appreciated.
Jo