Syntax problem

G

gr

Hello!
I want to set a filter but i'm having trouble with the
syntax. I want to filter depending on CatID which is the
second column of a cbo box. I tried to do it like this
with no success...
strFilter = "SubCatID.Column(1) Like " & Me!cboCategory

Does someone knows how to do it?

thx!
 
W

Wayne Morgan

If you just want to limit the items in the combobox's drop down, change the
box's Row Source. You may find it simpler to just use a query for the Row
Source and in that query refer to Forms!FormName!cboCatagory in the
criteria. In the AfterUpdate of cboCatagory, requery the second combo.

Me.SubCatID.Requery

http://www.mvps.org/access/forms/frm0028.htm
 
Top