Linking a Field of a Form to a Field of a Sub Form on another form

  • Thread starter Thread starter FA
  • Start date Start date
F

FA

Dear Freinds,
I really really need help in Linking a Field of a Form to a Field of a
Sub Form on another form.

I have a Form A , Form B and Form C.
Field1 is part of Form A and Form C (Form C is a subform of Form B)
I want to have a command button on Form A which will open Form B and
the Field1 should be pre-populated in FormC(Subform of FormB).

I tried many things but nothing seems to work for me.

Please Freinds i really need help.

Thanks

Moe
 
Because you nest a form does not mean they are/will link.
There needs to be a relation between a field in formA and a field in formB.
The same goes for a field in formB and a field in formC.
Then use Master/Child link between form and sub.
You will be able to add new records in formB then formC. But you must have
a record in formB before you can add to formC.
 
There is a relation betweent Form A (Table A)and Form C (Table C) they
both are joined with System_ID. But FormB (Table B) does not have any
relation with Form A but it doest have a relation with Form C(TableC).
Form B(Table B) and Form C (Table C) are joined with a STD_ID. I can
not have the System_ID in Form B (Table B) since there is no
relationship.

Please help me out!
 
Back
Top