Subform Filter
in [Getting Started]
|
Prev: Changing the names of fields in tables after creating other object
Next: Merge multiple records in the same table in access
From: Charess on 21 Dec 2009 14:46 I have a main form called "frmEmployeeDetails" and I have an issue form called "frmIssues". The Employee details form & the issue form are linked based off the employee name, which is a drop down box in the Employee Details table. (I know I should use employee number, but in this case I have to use the employee name as the primary key). This is the only field that actually gets entered in the Employee details table, all the other fields are dlookups based on the employee name. I currently have the issue form open as a pop-up window based off a command button in the Employee form. The issue form functions as a subform. However, the Issue form does not filter on open. It opens up to the first record. Once I start scrolling through the main form (the employee details form), the Issue form then begins filtering to the correct record. It's like there a latency issue. Any ideas on how I can resolve?
From: Jeanette Cunningham on 21 Dec 2009 14:55
Open the popup form using code like this--> DoCmd.OpenForm "NameOfForm", , , "[EmployeeID] = """ & Me.[EmployeeID] & """" Note: Replace EmployeeID with the primary key for the Employee table. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Charess" <Charess(a)discussions.microsoft.com> wrote in message news:05F7D51A-D79B-48BE-B0FD-132381A66D1E(a)microsoft.com... >I have a main form called "frmEmployeeDetails" and I have an issue form > called "frmIssues". The Employee details form & the issue form are linked > based off the employee name, which is a drop down box in the Employee > Details > table. (I know I should use employee number, but in this case I have to > use > the employee name as the primary key). This is the only field that > actually > gets entered in the Employee details table, all the other fields are > dlookups > based on the employee name. > > I currently have the issue form open as a pop-up window based off a > command > button in the Employee form. The issue form functions as a subform. > However, > the Issue form does not filter on open. It opens up to the first record. > Once > I start scrolling through the main form (the employee details form), the > Issue form then begins filtering to the correct record. It's like there a > latency issue. Any ideas on how I can resolve? |