Connect form1 to popup form2

Tekture

Registered User.
Local time
Today, 13:37
Joined
Dec 9, 2008
Messages
66
Form 1 has all the regular information for employees.
Form 2 has the dates of their "progress reports" for each year (you'll have multiple records for a single employee on Form 1)
Form 2 is also a popup (just a small window with a few date fields and a record selector so you can scroll through the multiple progress reports for that employee)

I guess what i need to do is filter form 2 depending on Form 1. The two forms 'frm HR Employees' and 'frm HR Prof' are linked together by their 'EmployeeID' within their respective tables: 'tbl Employee' and 'tbl prof'. The form 'frm HR Prof' is opened through a link on the main form 'frmHR Employees'

I've done this before, I just don't use Access enough to rememeber all these little tricks.
 
Ahh, let me clarify, the forms are working fine. The only problem i'm having is when i click the link on the main form and the popup appears, it has ALL records for ALL employees. I only want it to show me those recrods for the current employee the main form is on. The main form is also being filtered by a search function on a different tab.
 

Users who are viewing this thread

Back
Top Bottom