Pop Up Requesting Date

[dave5770]

Hi All,

I have a sheet that keeps track of tenants and their status. Data is kept on multiple sheets. I would like to have a pop-up come up requesting a date when the status of an entry in is changed to "notice" in table named tblTenants and the date is populated on in table tblUnits for the corresponding building and unit #. TblTenants has a one-to-many relationship with tblUnits as we could have many previous tenants listed in tblTenants. I simply want to avoid going back and forth between sheet and missing dates.

Example:

tblTenants (there are many more fields in this table but I removed them for simplicity)
[TABLE="width: 509"]
<colgroup><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD][TABLE="width: 981"]
<colgroup><col><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]ID[/TD]
[TD]BUILDING[/TD]
[TD]APT[/TD]
[TD]TYPE[/TD]
[TD]STATUS[/TD]
[TD]NAMES 1[/TD]
[TD]NAMES 2[/TD]
[/TR]
[TR]
[TD]

FRANCISAPT01​

[/TD]
[TD]

FRANCISAPT​

[/TD]
[TD]01[/TD]
[TD]APT[/TD]
[TD]CURRENT[/TD]
[TD]DARTH VADER[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]

FIRSTAVEPLACE02​

[/TD]
[TD]

FIRSTAVEPLACE​

[/TD]
[TD]02[/TD]
[TD]APT[/TD]
[TD]NOTICE[/TD]
[TD]LUKE SKYWALKER[/TD]
[TD]HAN SOLO[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

TblUnits

[TABLE="width: 958"]
<colgroup><col><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 958"]
<colgroup><col><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]ID[/TD]
[TD]BUILDING[/TD]
[TD]UNIT[/TD]
[TD]SQ.FT.[/TD]
[TD]TYPE[/TD]
[TD]UNIT STATUS[/TD]
[TD]NOTICE DATE[/TD]
[/TR]
[TR]
[TD]

FRANCISAPT01​

[/TD]
[TD]

FRANCISAPT​

[/TD]
[TD]01[/TD]
[TD]600[/TD]
[TD]1x1[/TD]
[TD]OC[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

FIRSTAVEPLACE02​

​

[/TD]
[TD]

FIRSTAVEPLACE​

[/TD]
[TD]02[/TD]
[TD]400[/TD]
[TD]0x1[/TD]
[TD]NOTICE[/TD]
[TD]DATE GOES HERE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]