Problem filtering a subform

[jjake]

Hello,

I have an unbound navigation form that houses a tabbed control. Within the tabbed control is a continuous form based on a query.

I can filter this form just fine if i open it by itself, but if i open it from within the navigation form i get an error.

Action or method is invalid because the form or report isn't bound to a table or query

It suggests to use the selectobject action. How would i do this?

 

[theDBguy]

Hi,

How exactly are filtering the subform? If using code, can you please show it to us? Thanks.

 

[jjake]

I'm using 3 command buttons that reference a combo box. Each one uses a macro using the apply where filter

[ProjectStatus]=1
[ProjectStatus]=2
[ProjectStatus]=3

 

[jjake]

bump........

 

[JHB]

Post your database with some sample data + description on how to reproduce your error.

 

[jjake]

Please see attached.

frmProjectManagement is the form that works correctly when opened alone but has a problem from my main form, under tab project management.

When clicking the command buttons to filter.

 

[theDBguy]

Please see attached.

frmProjectManagement is the form that works correctly when opened alone but has a problem from my main form, under tab project management.

When clicking the command buttons to filter.

Hi,

Thank you for posting a sample database. It helped understand your situation better. So, to fix your problem, rather than use the ApplyFilter macro action, replace it with the SetFilter macro action.

Hope it helps...

 

[JHB]

Here is the database.