macro error

[eric.l.bohon]

ALCON

Keep getting a error for a control button that does not work in a subform but works in a form by itself. Here is what I get:

I have a macro that has five ApplyFilter in it for five diverent forms. when i use it on the forms it works fine. but when I use that form in a subform then it stops working and gives me the Action Failed error.

any help on this.

 

[Dartagnan]

This might help.

http://support.microsoft.com/kb/112796

 

[boblarson]

Instead of using the macro, if you care to venture out into VBA world, we can help by using

Dim strWhere As String
 
strWhere = "[FieldName] = " & Me.Parent.SomeControlOnParentForm
Me.Filter = strFilter
Me.FilterOn = True

if the field is text you need to add quotes:

strWhere = "[FieldName] = " & Chr(34) & Me.Parent.SomeControlOnParentForm & Chr(34)

or if a date it needs Octothorpes (#):

strWhere = "[FieldName] = #" & Me.Parent.SomeControlOnParentForm & "#"