Refreshing Subform with Parent form record Set

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I hope i'm clear with my question

I have an access database for use by the Company's on HR person. One field is the EmpID and there is the record control arrows on the bottom of the form [just like the northwind Employees form] which goes from Employee to Employee

The subform [not designed by me - but i have modified it a bit] currently displays on the calendar, the vacation days taken by employee with id 1 on in the subform. What is not happening though is when i go to the next record, the subform is not being refreshed with the new empid so it's still showing the vacation days taken by the previous employee

I tried

recordnumber = Forms!Employees!EmployeeI

within the subform, but that doesnt refresh as the user navigates back and forth between records. Suggestions?
 
Hi Randy,

It sounds like your subform is not properly linked to the
main form. Check the properties for the subform
control. On the Data tab, you should see "Link Child
Fields" and "Link Master Fields". Enter the appropriate
fieldname representing the Employee ID for the main form
and subform in these two fields (Master is the Main Form
and Child is the Subform).

HTH

-Ted Allen
-----Original Message-----
Hi,
I hope i'm clear with my question:

I have an access database for use by the Company's on HR
Click to expand...
person. One field is the EmpID and there is the record
control arrows on the bottom of the form [just like the
northwind Employees form] which goes from Employee to
Employee.
The subform [not designed by me - but i have modified it
Click to expand...
a bit] currently displays on the calendar, the vacation
days taken by employee with id 1 on in the subform. What
is not happening though is when i go to the next record,
the subform is not being refreshed with the new empid so
it's still showing the vacation days taken by the
previous employee.
I tried:

recordnumber = Forms!Employees!EmployeeID

within the subform, but that doesnt refresh as the user
Click to expand...
navigates back and forth between records. Suggestions?
 
Back
Top