im trying to refer to a certain column of data in a combo box as criteria for a filter..cant get it to work ..is this possible? what am i doing wrong..heres what i got so far:
DoCmd.ApplyFilter , "[cbomm].Column(5) = [cost]"
thanks,
Raza
I have an append query that Im getting key validation errors on..in help it suggested I delete the links and then relink..but of course I couldnt find out how in the help system..
any ideas?
oops I forgot there were multiple sections to this forum..not used to it.. =/
anyway heres what I posted in general:
If I use a listbox on a form as a criteria for a query. How will the query handle the multiple selections possible in a listbox?
Ideally it will filter based on all selections...