filter subform with command button from within the subform

[brs]

hi,
i have a subform with fields like bookname, publisher, category etc.
i have comboboxes within the same subform which selects values; and a command button which is supposed to filter records corresponding to the combobox values.

i have a code like -


Me.Child2.Form.Filter = "[bookname]=" & [booknamecombo]
Me.Child2.Form.FilterOn = True

this obviously doesnt work as it filters from a command button in main form not subform. i want a code which works from within the subform. any ideas?

[pbaldy]

See if this helps:

http://access.mvps.org/access/forms/frm0031.htm

[brs]

looks promising. it'll take time to work out.
thanks for quick response.

[brs]

i typed -

Me.Form.Filter = "[book name]=" & Me!BooknameCombo
Me.Form.FilterOn = True

it shows run-time error 3075 syntax error (missing operator) in query expression '[book name]= ComboboxValue'

help

[pbaldy]

If the field is text try

Me.Form.Filter = "[book name]='" & Me!BooknameCombo & "'"

[brs]

does work !!! thanks a lot Paul.

now how can i add wild card character to the syntax so that i can search for the book from anywhere in the field. i tried something like-

Me.Form.Filter = "[book name]='" * " & Me!BooknameCombo & " * """"

this doent work. also i need to know how can i add other fields with 'add' like
Me.Form.Filter = "[book name]='" * " & Me!BooknameCombo & " * " and " * " & Me!BookAuthorCombo & " * "
please help

[pbaldy]

Try

Me.Form.Filter = "[book name] Like '*" & Me!BooknameCombo & "*'"

[brs]

book name and author filters individually but when i try to add 'and' and type -

Me.Form.Filter = "[book name] Like '*" & Me!BooknameCombo & "*'" And "[Author] like '*" & Me!AuthorCombo & "'"

this shows runtime error - 13 - type mismatch
where am i getting wrong?

[JeroenMioch]

Your missing a wildcard at the end of the code, it may be the error.

Me.Form.Filter = "[book name] Like '*" & Me!BooknameCombo & "*'" And "[Author] like '*" & Me!AuthorCombo & "*'"

[brs]

nope. it still doesnt work. besides i dont really need wildcard at the end.

i double checked that filter on author works perfectly if applied individually. the error shows only with 'and'

[JeroenMioch]

Try this :

Me.Form.Filter = "[book name] Like '*" & Me!BooknameCombo & "*' and [Author] like '*" & me!AuthorCombo & "'"

[JeroenMioch]

Ive tried above code on my database (just to make sure im not making a fool of myself) and it works for me.

[brs]

well you were not making a fool of yourself. it does work!!
thanks a lot

[JeroenMioch]

Your welcome mate