Linking form fields????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have two forms which are "linked" by a command button. There is a field on the first form that I would like any data that is entered into it, to automatically show up in a corresponding field on the second form. Also, will the kind of link I've used between the two forms, mean that any info put into the first and subsequently the linked form, will save as the same record number in the various tables??? (hope that makes sense)!!!

Ta :)
 
What do you mean by linked? The only way to establish a relationship
between two forms is if one is a subform of the other or if both forms use
the same record source. Assuming your forms are 2 independent forms, the
only way to have the same data show in both forms is to have them both use
the same record source (can also be different queries based on the same
table). You will need to refresh the second form to update the display. If
you have 2 forms based on 2 tables, the only way to get the same info into
both tables would be to use a form/subform approach or to use VBA (coding).

Kelvin

Yasmin said:
Hi,

I have two forms which are "linked" by a command button. There is a field
Click to expand...
on the first form that I would like any data that is entered into it, to
automatically show up in a corresponding field on the second form. Also,
will the kind of link I've used between the two forms, mean that any info
put into the first and subsequently the linked form, will save as the same
record number in the various tables??? (hope that makes sense)!!!
 
Back
Top