Trying to run an event on opening form based on data in another table

[DC27]

I've an actions log database containing open and closed actions in a table called tblActions.

I have another table called tblDefaults - this has a number of yes/no fields asking if the user wants to see open actions only by default when they open the form.

I have a form for adding and updating actions called frmActions that is linked to tblActions. What I would like to be able to do is for the user to see all actions or just those remaining open as he has selected in the defaults table.

I have a number of tables I’ll be using this for, so any help would be greatly appreciated