set value

[Guest]

I have two forms. When I type on the right side form (subform), I want to
update the left side form(main form).

Currently, I was using a macro with the set value command.
But, this only works for numeric fields. When I try to use this same macro
on a text field, the macro fails.

Any help would be appreciated.
Thanks,

 

[Joseph Meehan]

Do you mean you want to add a record in the parent table when you are
adding a record to the child table?

What version of Access are you using?

 

[Guest]

No, sorry I didn't explain it well. I have a main form and a subform which
are actually just alike. I bring the old record into the main form and if
they want to make changes on the subform, I want to update the main form to
show those changes. The subform has a field called address. If the address
is changed on the subform, the macro sets the field on the main form to that
value and with conditional formatting, I change the color to red to show that
the value has changed. I wll eventually store all the changes in the main
form so that I can keep track of the original and all corresponding changes.
The only thing in my macro is the Set Value command which is ON EXIT
property of the subform field. This updates the main form field and turns it
red showing that it has been changed.
Does this explain it enough?
Thanks for your help.

 

[Guest]

Sorry,
I am on version Access 2003.
--
Joan

No, sorry I didn't explain it well. I have a main form and a subform which
are actually just alike. I bring the old record into the main form and if
they want to make changes on the subform, I want to update the main form to
show those changes. The subform has a field called address. If the address
is changed on the subform, the macro sets the field on the main form to that
value and with conditional formatting, I change the color to red to show that
the value has changed. I wll eventually store all the changes in the main
form so that I can keep track of the original and all corresponding changes.
The only thing in my macro is the Set Value command which is ON EXIT
property of the subform field. This updates the main form field and turns it
red showing that it has been changed.
Does this explain it enough?
Thanks for your help.