What is wrong with the following code?
I am trying to filter a form based on the selection of a combobox
named cblPRD

Dim currentFilter
currentFilter = "[prdID] = '" & Me!cboPRD & "'"
Filter = currentFilter
DoCmd.ApplyFilter , Filter

When the code executes, I trap and receive the following error...

Error Number: 2501
Error Description: The ApplyFilter action was cancelled

dkohel (AT) gmail (DOT) com wrote:

I sometimes set filters with code similar to

Me.Filter = "ID = 123"
Me.FilterOn = True

Twilight Zone
http://www.youtube.com/watch?v=a1sf2CzEq0w

Seems as though this issue only occurs when I have the prdID set as a
primary key. When I remove the primary key setting on that field, it
works fine. Any ideas why?

On Jan 22, 8:23 pm, "dko... (AT) gmail (DOT) com" <dko... (AT) gmail (DOT) com> wrote: