The question is where is your Lease Number field stored and what is the recordsource for your main form?
You need to tell us a little bit about how your main form and tables are setup. Is your main form's recordsource based on your main data table? If so, is Lease Number a field in your main data table? If not, why is it in each of the relational tables?
Do your tabs have subforms in them which might be based on relational tables to the main data table?
You won't need a script to show the Lease Number on the main form. You can set the sourceobject of a field on your main form to equal the Lease Number field wherever it's located.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)