how to unrelated sub form in master form

[yantan2006]

Good day to all,

I created a master form [internet users] which carries 2 sub froms [MobileForm Sub] and [device Form Sub]. All these three forms are working fine, since these forms share the same user i.d

I inserted another subform [connection sub form] which doesn't have user i.d but it is linked with one of the subforms [device sub form] with [device I.d] or [DID]in the master form



now connection sub form doesn't get filter as device i.d changes in devices sub form.

how to apply filter or make connection sub from filter and get updated as did changes.

photo attached for your kind reference.


Kind regards

[ItsMe]

You can have more than one Master/Child Link relation defined in a subform control. Since the main form has two fields that can be linked, as a compound key, include both in the second subform's Master/Child Link property.

Another possible solution might be to include the second subform within the first subform. In other words, open the form object that is the first subform's SourceObject in design view. Add a subform control and use the last form object as the Source Object. Use the Master/Link

[yantan2006]

Thank you for your assistance....

Master form and table doesn't has any common field in the child table. Both tables and forms are unrelated.

however my intended form has one common field in one of the subform in the master table and I need to link that subform with my intended unrelated subform. (in one master form)

looking forward to hear from you

[ItsMe]

I see. I re-read your original post. I was thinking you only had two subforms. I guess you could try adding the third subform directly to the main form and include two Master/Child links. However, it seems you need an OR operator. So, adding [device I.d] OR [DID] may not be possible. I think I remember it being mentioned as possible, but a solution is eluding me at the moment. Maybe someone else here remembers how, if it is possible.

It may be necessary to use the OR operator in the third form's recordsource and abandon the use of Child/Master for the third subform. This would require VBA and it might not be suitable for your needs.