Auto fill in tab (1 Viewer)

foxtet

Registered User.
Local time
Today, 19:29
Joined
May 21, 2011
Messages
129
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
 

Attachments

  • autofill.zip
    869.3 KB · Views: 41

RuralGuy

AWF VIP
Local time
Today, 09:29
Joined
Jul 2, 2005
Messages
13,826
BTW, you should be aware that SubForms load *before* the MainForm!
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:29
Joined
May 7, 2009
Messages
19,175
please try this.
 

Attachments

  • autofill.zip
    529.8 KB · Views: 53

foxtet

Registered User.
Local time
Today, 19:29
Joined
May 21, 2011
Messages
129
I want those data to be saved in tblInvoice.
 

foxtet

Registered User.
Local time
Today, 19:29
Joined
May 21, 2011
Messages
129
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

Registered User.
Local time
Today, 19:29
Joined
May 21, 2011
Messages
129
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
 

Users who are viewing this thread

Top Bottom