Populate Subform with MainForm Data

[mfaisal.ce]

Dear Friends,

I have a main form with subform, what i need is when i change value of main form and record exits then populate data for subform based on main form value else clear subform for new data entry....
Kindly guide,

Main Form: FrmSales
Main Form Field: SNo (Primary Key)

Subform : FrmSales_Detail
Subform Field: SNo (Foreign Key)

Subform: FrmPayment_Detail
Subform Field: SNo (Foreign Key)

regards,

 

[arnelgp]

bring your form in design view.
click on the subform.
add Master/Child Link Fields using both SNo.

 

[mfaisal.ce]

Brother,
i agree what u said.... but if works only when u do navigation in records. but if u enter any value in master field with existing record, it doesnot populate child records in subform.... this is my problem......

 

[Dreamweaver]

Are you tying to link a ID or copy other value?

 

[arnelgp]

what value are you trying to change the SNo?
try adding relationship to your tables and
add Cascade Update to the child tables.

 

[mfaisal.ce]

Dear,

What i need is very simple... sorry, if i am not able to elaborate my problem.... i will try again,

I have a combobox "SNO" on Main form, when ever i will write any value here... if the record with that "SNo" exits, it will populate the mainform & subform accordingly else create the new record.... Plz see the attached image

 

[arnelgp]

make the combobox Unbound and the Main Form bound.
on AfterUpdate event of the Sno combobox, add code:

private sub combo_afterupdate()
if me.combo.listindex > -1 then
    with me.recordsetclone
        .findfirst "sno = '" & me.combo & "'"
        if not .nomatch then
            me.bookmark = .bookmark
        end if
    end with
end if
end sub

make sure that the subform has master/child link fields.

 

[mfaisal.ce]

thanks dear... but i cant make combobox unbound because this is bound with SNo field of master form ( Master Table "Sales" with primary key in Field "SNo"), if i will make it unbound then how i will save record in Master Table....

1. Master Table "Sales"
Fields: SNo, CustomerID

2. Child Table "Sales_Detail"
Fields: SNo, Qty, Price

 

[Dreamweaver]

Create a second one with the wizard as a lookup combo

 

[arnelgp]

the purpose of the combo is to "search" your table.
if you make it bound, it will just over-write the Current record.

you need to find a way to "add" a record if there is no
matching record when on it search.

 

[mfaisal.ce]

the purpose of the combo is to "search" your table.
if you make it bound, it will just over-write the Current record.

you need to find a way to "add" a record if there is no
matching record when on it search.

Ok bro... Leave combobox.... Suppose i have a text box "SNO"... After update value in SNo txt box, if records exist in main form and subform then show them , else keep all blank....