Pop up Reminder Implementation!

[jepoysaipan]

Hi Guys,

I have 3 tables:

tblEmp (Employee Table)
EmpNo (PK)
EmpName (Text)
Address (Memo)
Phone (Text)
HireDate (Date/Time)

tblAssignments (Assigment Table for the employee)
EmpNo (Text)
Client (Text)
Location (Memo)
TicketDate (Date/Time)
Done (Yes/No)

tblEmpMemo (Employee's Note)
EmpNo (Text)
ReportMemo (Memo)
RepDate (Date/Time)
RepDone (Yes/No)

I was making a reminder pop-up upon opening the .MDB, I was able to execute only one table at a time, What I need is to create a single form that includes all the 3 tables and have a common fields (e.g.)

EmpNo Reminder Date Complete
0001 Employment Renewal 09/15/2008 No
0001 Site Visit (Mirage Hotel) 11/21/2008 No
0002 2 rolls Siamese Cable for 11/21/2008 No
ABC Mart Surveilance Camera
0003 On-Leave up to 12/28/2008 11/25/2008 No
0005 Employment Renewal 11/25/2008 No

Ok, its a more complicated concept The first and the last record was based on the tblEmp HireDate (should pop-out 2 months in advance), second record was based on tblAssigments and the third and fourth record was based on tblEmpMemo.

Now the complicated part, I waqs trying to get all the records into 1 table using CrossTab Query but when the pop-up window appear I need to do some changes to the tables involve, for example i need to change the status of a particular entry I just need to check the "Complete" field to disable the reminder in the future.

Your precious help is highly appreciated!

Jeff