UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Passing Data Form One Sub-form To Another Sub-form, Any Version    
 
   
popins
post Mar 8 2018, 01:38 AM
Post#1



Posts: 1
Joined: 7-March 18



Good Day to All,

I am very new Access. Sorry my English was not good. I Have two Parent table with child table, for Quotation and Invoicing, as shown below.
Once our quote is approved we need to convert the quote for certain line items as invoice. For this I need to select some line items in quotation sub-form and pass the same to invoice form by a button click.

how to copy the selected item in quotation line form to Invoice line form.

Can anyone help me to prove the code for this button click.

Tables:
Quotation(Table) - Parent
Quote Number(Primary)
Quote Date
Customer Name

Quotation Line(Table) - Child
QuoteNumber
S.No
Description
QTY
Unite Price
Select

Invoice(Table) - Parent
Invoice Number(Primary)
Invoice Date
Customer Name

Invoice Line(Table) - Child
Invoice Number
S.No
Description
QTY
Unite Price




Attached File(s)
Attached File  Access.jpg ( 49.39K )Number of downloads: 8
 
Go to the top of the page
 
RuralGuy
post Mar 8 2018, 09:19 AM
Post#2


UtterAccess VIP
Posts: 2,826
Joined: 25-June 05
From: @ 8300' in the Colorado Rocky Mountains


Maybe this link will help: http://theaccessweb.com/forms/frm0031.htm

--------------------
(RG for short) aka Allan Bunch Previous MS Access MVP acXP, ac07, ac10, ac13 - WinXP Pro, Win7 Pro, Win10 Pro
Please reply to the forum so all may benefit.
Go to the top of the page
 
projecttoday
post Mar 8 2018, 09:34 AM
Post#3


UtterAccess VIP
Posts: 10,069
Joined: 10-February 04
From: South Charleston, WV


welcome2UA.gif

An INSERT statement will copy the data.

--------------------
Robert Crouser
Go to the top of the page
 
projecttoday
post Mar 8 2018, 01:37 PM
Post#4


UtterAccess VIP
Posts: 10,069
Joined: 10-February 04
From: South Charleston, WV


I think you could use the form and subform's recordset as the source.

--------------------
Robert Crouser
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    25th September 2018 - 06:01 AM