Dialog when Field is Populated

[Jscott]

If someone clicks on a button to go to a specific layout, I want a Dialog to open and redirect them back to the original layout if a specific field is populated.

Thanks,

Stumped

[LaRetta]

That's not a lot to go on but the button which switches layouts can hold the script (if it is based upon the same table occurrence). It might be something like:

If [ IsEmpty ( thatField ) ]

Go to Layout [ the other layout ]

Else

Show Custom Dialog [ OK ; "you can't go to that layout" ]

End If

But again, we have little information about whether the other layout is from a related table, another file or in a new window showing a different found set. If the 'field' which should be empty is within the same RECORD and you jump to another layout (based upon the same table occurrence) then you can test before the jump and not jump at all (if the field isn't empty).

[Jscott]

Thank You. Sorry I was not more specific, but you answered my question very well!