form with 2 subform

willsnake

Registered User.
Local time
Today, 23:32
Joined
Dec 3, 2018
Messages
52
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...
 

Attachments

in my TblPurchaseRequest form, it somewhat works...
 
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.
 
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...
 
Advice already given is all I know about.
 
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
 
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
 

Attachments

I will try all your suggestions...

Thank you Very Much...
 
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...
 

Users who are viewing this thread

Back
Top Bottom