Automation: How to Fill another form with values of first form

[sumox]

a hi ! all there

i just created two forms which r so inter-rel. with each other
1. FormName : Invoice_SL
Form controls which need to be copied to another
form :
a> PO No b> PO Date c>Dispatch Details
d> - is a filtered list depending upon UID of Invoice_SL Form

2. formName : Challan_DLR
Form fields are :
ChallanID, Challan Date, PO no., PO Date, Dispatch Details
list of items to be sent-- a filtered list depending upon UID
of Invoice_SL form

now what i want:
Just a command button in Invoice_SL Form to Open(pre-made form)
Challan_DLR form and Copy-paste all these controls (same named)
from Invoice_SL to Challan_DLR form

howww to do the stuff?

 

[RuralGuy]

Is the Challan_DLR form based on a query? If not, why not?

 

[sumox]

shud challan_DLR form shud be based on Query whos fields taken from Invoice_SL
filtered by UID value of Invoice_SL

 

[RuralGuy]

What is the record source of the Challan_DLR form? What is the record source of the Invoice_SL form? Do they have any field in common?

 

[sumox]

YES THEY HAVE
invoice_no
field in common . As any Material issued needs to be put up a invoice serial no.
so they have invoice_no field in common

 

[RuralGuy]

Excellent. In that case you can create a query that includes both tables joined on the invoice_no field and include the fields from the Invoice_SL table that you want to appear in the second form. No need to do any copying of controls on your form. Then as long as you have saved the values in the first form, this should give you what you want when opening the second form: http://www.baldyweb.com/wherecondition.htm