Auto Date in Subform

[Jody :o)]

Hello,

I think this might be a fairly easy thing to do, although I am unable to
figure this out. I keep track of my daughter's homeschool grades on a
database I created. I have a mainform where I enter the date of her
attendance and in it I also keep track of her subjects/grades in a subform.
I don't want to have to keep typing in the date for every grade I put in for
the day, nor do I always enter the grade for each day.

Is there a way that I can just enter in the date in my mainform once and it
automatically enter the date into my subform?

Thanks for your time. I don't know what I would do if I didn't have this
group to turn to.

FYI, I use AT_ID as the linked child and parent fields.

 

[John W. Vinson]

I think this might be a fairly easy thing to do, although I am unable to
figure this out. I keep track of my daughter's homeschool grades on a
database I created. I have a mainform where I enter the date of her
attendance and in it I also keep track of her subjects/grades in a subform.
I don't want to have to keep typing in the date for every grade I put in for
the day, nor do I always enter the grade for each day.

Is there a way that I can just enter in the date in my mainform once and it
automatically enter the date into my subform?

Thanks for your time. I don't know what I would do if I didn't have this
group to turn to.

FYI, I use AT_ID as the linked child and parent fields.

If the AT_ID uniquely identifies the date, then the date field *need
not and should not* be copied into the subform's record. You can
always find it by just creating a query joining the two tables on
AT_ID.

If you wish, you could use the date field as the Master and Child Link
Field instead of - or in addition to - the AT_ID. If you use both,
separate the fieldnames (in brackets) by a semicolon in the Master and
Child Link Field properties.

John W. Vinson [MVP]

 

[Jody :o)]

John,

You've been the most patient with me and easiest to understand. You explain
things so thoroughly. Thanks a MILLION!!

Jody ) ) ) )