Expression Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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
 
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
 
Back
Top