If a user selects one particular option from the dropdown I would like a dialogue to appear along the lines of "Would you like to create a new record in [FormName] for this record.

If the user selects Yes, another form opens and data is transferred from the one form to the other.

If the user selects No, the dropdown in the first for is change to a different pre specified option.

I can handle the actions and data transfer, but do not know how to create the Yes/No dialogue.

Any help gratefully received, thanks.