filter to display records MS ACCESS 2010???

[jmasm]

Create a filter to display only those records that have the criteria required?
I'm using this code:

DoCmd.OpenForm "Formname"
Forms!Formname.Form.Filter = "Data = " & Me.Datacriteria
Forms!Formname.Form.FilterOn = True

When I run the program the following error appears:

Run-Time error '2448'
You can't assign value to this object.

Help please!!!

 

[PHV]

Have you tried this ?
DoCmd.OpenForm "Formname", , , "Data = " & Me.Datacriteria

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jmasm]

Works with only one criteria.
When I try to use more then one criteria with this code:

DoCmd.OpenForm "Formname", , , "Data1 = " & "'"& Me.Datacriteria1 &"'" And "Data2 = " & "'"& Me.Datacriteria2 &"'"

When I run the program the following error appears:
Run-Time error '13'
Type mismatch

 

[PHV]

I'd try this:

DoCmd.OpenForm "Formname", , , "Data1='" & Me.Datacriteria1 & "' And Data2='"& Me.Datacriteria2 & "'"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886