Expression Help

[Guest]

Can anyone tell me the expression to put into the Control Source of my
subform. I want to put the date that is in the main form into the subform.
The tables and fields are:
TblOngoing Assessment4
AssessmentDate

SubTableOngoing Assessment A
AssessmentDate

It would save me time when entering the data.

Thanks in advance.

 

[Jeff Boyce]

Why? As in "why do you want to redundantly enter (or have Access enter) the
same value in more than one table? Access is a relational database. You
might have one of those special circumstances that warrant it, but,...?!

If you'll provide more description about why you are trying to do this, and
what having the same value in two tables will allow you to do, the newsgroup
readers may be able to offer alternate approaches.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[ajetrumpet]

=Forms![main form name]![control name that holds the date]
???

 

[Guest]

Hi Jeff

Thanks, I am setting up a database for the first time and think I am being
overly cautious. The date is in the main form so yes you are right I do not
need it in the sub form. There is no one in the office that has worked with
Access so I am flying by the seat of my pants "Pardon the pun"

Many thanks for your help

 

[Jeff Boyce]

A minor semantic quibble, only justifiable because you are starting
out...<g>

Access does not store data in forms. Tables store data, forms display it.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP