Apply Filter adds an empty record

V

Venus

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.
 
V

Venus

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.
 
Top