Hi
This is pretty hard to describe. I have a form which contains a subform in a 1 to M relationship. In the main form the user creates a flight. In the subform the user has to allocate multiple crew to the flight. I am looking for some way to validate whether the crew are in fact the correct crew for the flight (eg. by referencing the crew persons job title).
I know some for of data validation macro would do the trick, but at what point should it be triggered? Not when the form is saved (as this may happen at any time) and not when the crew sub-form are navigated (as the user may wish to do this several time before committing his/her crew selections).
Any help greatly appreciated.
This is pretty hard to describe. I have a form which contains a subform in a 1 to M relationship. In the main form the user creates a flight. In the subform the user has to allocate multiple crew to the flight. I am looking for some way to validate whether the crew are in fact the correct crew for the flight (eg. by referencing the crew persons job title).
I know some for of data validation macro would do the trick, but at what point should it be triggered? Not when the form is saved (as this may happen at any time) and not when the crew sub-form are navigated (as the user may wish to do this several time before committing his/her crew selections).
Any help greatly appreciated.