Apply Filter adds an empty record

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

Guest

I'm using a combo box to list employees and then retrieving the records on
the form using a macro on the AfterUpdate event.
In the macro I use the applyfilter action. The Where Condition is:
[Forms]![Expenses]![EmployeeID]=[Expenses]![EmployeeID]
It gets the matching records but it gets an empty record as well and then
saves that to the table???? What am I doing wrong.
 
Never mind!
I had the control source of the combo box as a database field, thats why it
was adding a record. I changed it to unbound and it works fine now.
 
Back
Top