form with 2 subform (1 Viewer)

[willsnake]

Good day,

I am here again seeking help. But before I post here, I have tried many times but failed...

What I am trying to accomplish is that the form TblPurchaseOrderNEW will have 2 subform same as the form TblPurchaseRequest with the same function... I have set the relationships but when I add subforms, the link for the 2nd subform fails or there is error...

Attached is the Access I had...

Sorry for the bother, but I had already spent 1 week trying to figure out..

Thank you...

 

[June7]

Well, that really won't work. Either [TblPOLotParticular subform1] needs to be a subform on [TblPOLot subform] or review this:

https://www.fmsinc.com/MicrosoftAccess/Forms/Synchronize/LinkedSubforms.asp

 

[willsnake]

in my TblPurchaseRequest form, it somewhat works...

 

[June7]

Syntax on that subform link is different from what you have on the Order form. For MasterLink try [TblPOLot Subform].Form![POLotID].

I've never actually seen this used. Think it would be described everywhere if it works.

 

[willsnake]

I already tried this "[TblPOLot Subform].Form![POLotID]"

But it also does not work...

Any workaround for my problem? I am open for suggestion...

I am very sorry for the bother...

 

[June7]

Advice already given is all I know about.

 

[MajP]

The easiest way to synch two subforms is to put a hidden text box on the main form. Lets call it txtLink. On subform 1 on the on current event populate txtLink.

Me.parent.txtlink = me.NameOfLinkingField

in the second subform you link to the control txtLink
Link Master Fields: [txtLink]
Link Child Fields: POLotID

 

[bastanu]

Hard to say what you want to accomplish with no data and/or a better explanation, have a look at the attached and see if that is getting closer.

Cheers,
Vlad

 

[willsnake]

I will try all your suggestions...

Thank you Very Much...

 

[willsnake]

the solution to my problem was a basic way of creating a form which is to include all table I need in the form instead of manually adding subform...

Sorry for the bother...

Thank you very much of your time...