Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Subform Filter
0 views
Skip to first unread message
Charess
Dec 21, 2009, 2:46:02 PM12/21/09
to
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.
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?
Jeanette Cunningham
Dec 21, 2009, 2:55:12 PM12/21/09
to
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" <Cha...@discussions.microsoft.com> wrote in message
news:05F7D51A-D79B-48BE...@microsoft.com...
0 new messages