Syntax problem

  • Thread starter Thread starter gr
  • Start date Start date
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!
 
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
 
Back
Top