Run time error 2448

Topic

New Reply

I received the following error, “Run-time error 2448 You can’t assign a value to this object.”

I have a command button on the main form that filters a subform check box.

Here is the code:

With Me.frmZip_info.Form
.Filter = “Select = -1”
.FilterOn = True
End With

Any ideas why?

Thanks!

Reply | Quote

Replies

Is frmZip_info being used as a subform on a main form (whatever Me. is)? If so you need to reference it using the subform control name. Otherwise I don’t see anything wrong with your code.

Reply | Quote

With Me.frmZip_info.Form
.Filter = “Select = -1”
.FilterOn = True
End With

Assuming frmZip_info is the name of the subform control, any chance this control is locked or not enabled? Or that the AllowFilters property of the subform itself is set to No?

Reply | Quote