I just converted from Access 97 to 2000. I have for several years successfully used a form, in which a combo box contains a list of names. A macro runs After Update when a name is selected and the form displays records containing that Employee Name. Since converting to Access 2000 only the records for the first name you selected will display. Even, if you select another name, i still displays the first name's records. The only way select a different name is close the form and reopen.

Here is macro: Line 1: Action-Apply Filter, Action Argument-Where Condition [EmployeeName]=[Forms]![frmSearchDetail]![cboFindName]
Line 2: Action-Set Value, Action Argument-Item: [Forms]![frmSearchDetail]![cboFindName]
Expression: Null
Line 3: Action-Set Value, Action Argument- Item: Section(0).[Visible]
Expression: Yes

Any assistance will be greatly appreciated!