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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GoTo a record from a combo in the form 4
ApplyFilterCode 1
Combo Box Filter 1
How to use a combo box in a bound form? 3
filtering on subform 1
cloning a record 5
Combo Box Problem 1
Print Current Record 9

Back
Top