subform used in 2 forms

[megatronixs]

Hi all,



I have an audit trail subform that I used first in one form. Now I need to use it in a second form as I have a version with limited things for other users.
these are the 2 forms: "frm_admin_analyst" and "frm_admin_main" the audit trail form: "frm_AuditTrail_subform"
the load event of the "frm_AuditTrail_subform"

Option Compare Database
Private Sub Form_Load()
    
    Me.Filter = "[tblAuditTrail].[RecordID]=[Forms]![frm_admin_main]![record_id]"
    Me.FilterOn = True
End Sub

Is it possible to make them both use the same audit trail form?

Greetings.

[June7]

Why do you need to use code to set Filter property of frm_AuditTrail_subform? Are you using the Master/Child links properties of the subform container control?

[megatronixs]

Hi June7,

It does not work. I keeps asking to put in the ID nr and then it will connect just fine the correct record.
Is it maybe because I did copy the form and then did rename it?

Greetings.

[June7]

Don't really understand what you mean. You say it does not work then say it connects just fine. What does copying form have to do with setting the Master/Child Link properties?

[megatronixs]

hi June7,

When I open the form, the code from the first post will check which record I have selected and pass it to the subform to show those records that are connecte via the record_id.
but it does not do it, instead I get a small box poping up asking me the record_id, when I type in the one I try to open, then it will pop up the right record.
I have simply 2 forms that have the same subform in them. One of the form just opens correctly with the record_id and the second form just ask for the record_id (like a parameter query)

Greetings.

[June7]

I don't understand this setup. If you are using subform, why do you need code and not just use Master/Child Links properties? If you want to provide db for analysis, follow instructions at bottom of my post.