Auto fill in tab

[foxtet]

Dear Guys,
I have problem in auto fill in tab. In the attached database On the update delivery and invoicing form is placed a tab control which has two pages.
1) pageDelivery
2) PageBilling

in PageBilling I want automatically fill in consignee and shipper names.

foxtet

 

[RuralGuy]

Perhaps this link will be useful: http://access.mvps.org/access/forms/frm0031.htm

I see no control on the "Parent" form named "txtParentInvoice"!


Me.Parent!txtParentInvoice

 

[RuralGuy]

BTW, you should be aware that SubForms load *before* the MainForm!

 

[arnelgp]

please try this.

 

[foxtet]

I want those data to be saved in tblInvoice.

 

[foxtet]

When ShipperID is selected from pageDelivery to appear that record refresh button need to clicked.how can this be achieved by re querying.

foxtet

 

[foxtet]

Thank you,

How can we save those two records in tblInvoice.
When I put the following [Forms]![frmUnBilledEntries]![txtHiddenConsignee] as default value of txtConsigneeId text and its control source to consigneeID of underlying table the text box show blank.

If any solution please share

foxtet