value in a field of one form to equal to value in a field of anoth

[T3E]

hi wanted to now if it is possible to make a value in one form equal to the
value in another form.
for instance i have a form called properties and another called tenant in
the property field i have the monthly rent field and in the tenant form i
have the same field.

i wanted to know if someone can give me the correct formula to put in the
control source for the rent field.

i tried this it didn't work.
=[Forms]![formname]![fieldname] it doesn't work. can u help me please?

 

[Wayne-I-M]

Hi

Better still. Create 2 querys to run the forms. Ensure that your table
containing the monthly rent to in both querys - this way you will only need
to update one form to have the data updated in both forms.

Of course you "could" refer to the 1st form but this could lead to errors if
both forms are not open "and" could also lead to errors if both forms are
alter with 2 different amounts.

Best to have the data stored in only one place then there will not be any
errors.