Save data in a subform

[vito1010]

Greetings,



I have a form (Christmas Card Master List) and a Subform (SR). The main form has name, address, salutation, etc... The subform has two check boxes (Sent & received) and a text box which is set to YEAR(NOW()). They are set in a relationship (ID-ID). How can I store the year so that when I open a record (Mr & Mrs Jones) in 2015, that the 2014 info (Sent/Received) still has the 2014 date in it. I know this sounds a little confusing.

Thanks,
Vito

[June7]

What is the subform bound to? Isn't it a table of records that provide history of cards sent?

Yes, I am somewhat confused. Do you want to display the last year a card was sent? Doesn't the subform display all the history records? Can use DMax() expression in textbox on main form.

Can a record be either sent or received, not both? If yes, then should be one yes/no field (or a text field with two options), not two.

[Missinglinq]

Like June7, I'm a little confused, too! But the Textbox has to be Bound to a Field in the underlying Table that the Subform is Bound to. If you're using the

=YEAR(NOW())

in the Control Source for the Textbox, you need to move that to the Default Value Property and place the underlying Field's name in the Control Source.

Linq ;0)>