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)

ID BUILDING APT TYPE STATUS NAMES 1 NAMES 2 FRANCISAPT01​ FRANCISAPT​ 01 APT CURRENT DARTH VADER FIRSTAVEPLACE02​ FIRSTAVEPLACE​ 02 APT NOTICE LUKE SKYWALKER HAN SOLO <colgroup><col><col><col><col span="2"><col><col></colgroup><tbody> </tbody>

<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>

TblUnits

ID BUILDING UNIT SQ.FT. TYPE UNIT STATUS NOTICE DATE FRANCISAPT01​ FRANCISAPT​ 01 600 1x1 OC FIRSTAVEPLACE02​ ​ FIRSTAVEPLACE​ 02 400 0x1 NOTICE DATE GOES HERE <colgroup><col><col><col span="2"><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>