Ignoring Required field

[hcompston]

Hi All

Be gentle as im new here I have tried to look through the posts but to be honest I am still learning the terminology so I might just not be looking for the right thing.

Here is my problem

I have a form that contains the data for accidents. The first entry on the form is the name of the victim. The victims name can be selected from a dropdown menu. However if the name is not there the user must click on another button to bring up the Add Victim form. Now here is the problem. As the Victims Name is a required field I cannot leave this field without completing it as I get a required field dialog. From what I can gather this is because the field is dirty even though it could be empty.

What I am trying to achieve is this. The user starts to enter the name of the victim and realises it is not there in the Database. They can then click the button to move to Add Victim form and this button then completly ignores the forms current data and moves to the requiredd form.

The problem I think is not with creating a button but with being able to leave the field dirty.

One solution I have found works is hitting the Esc key twice. I can then press the button and move to the required form with no errors.

Maybe the solution is realy easy but I cannot see it..

Thanks in advance

Harry

 

[namliam]

You can use the "Not in list" event to trigger the form to add the victim without the use of the "extra" button

 

[CEH]

It sounds like you have your validation code on the field...combo, and not on the forms beforeupdate event......

 

[boblarson]

As namliam said, use the Not In List event to deal with this. See here for more about that.

 

[hcompston]

Hi all

Thank you very much for the information. That has helped to clarify what is going on alot. I will go away and work through your suggestions.

Thanks

Harry

 

[hcompston]

This bit of code sorted the problem out for me ...thanks all for helping and thanks bob for the link

As namliam said, use the Not In List event to deal with this. See here for more about that.