link between two fields

[yoavchen]

i have a button that open another form. the form should copy some filed from the form that the button in it.

Example. i have the from-A with field name- ID. in this form there is a button that open form-B.
this form had also the field ID and another fields of information on the specific person (with the same person form the form_A)
i want that the ID will automaticlly updated whrn i open the form so i can add another information. these are teo tables that are linked together and that is the reason that witohut the ID it cant be updated, and i dont want to update it manually.

 

[MStef]

Hello Joavchen!
Try with a SUBFORM instead of ANOTHER FORM.

 

[yoavchen]

how can i do it? what is it a subform?

 

[MStef]

Hello yoavchen!

Look at "DemoSubA97.mdb"

 

[yoavchen]

Thnks

but this is not what i meant...
i want abutton that opens me the records of the person i point at in the main form.

Look at the file that you sent me. i want to have a button that when i click on it, the data of the 'subform' appears, but in another form that being opened by clicking on the command button

 

[Rich]

The Form wizard will create this for you, instead of selecting Form/subForm select Linked Form instead when prompted.

 

[yoavchen]

where is this wizard, when i am opening a new form?