I know this might seem technically wrong and therefore, I haven’t found
advice on how to do it on these postings. I have an Access 03 table
“EventTable1” with fields “StartTime” and “EndTime”. These times are the
actual times of our events. I have another table “StaffTable1” with fields
”ActualStartTime” and “ActualEndTime”. I want to track all these times in
the table and want the actual start/end time fields to default to the
start/end time fields. Many times they’ll be the same, but sometimes they
won’t. Any simple ways of doing this using the default value in table design?

Thank you!

Thank you for your suggestion about DLookUp! In case anyone else has this
problem and is following along, I asked a related question called “DLookUp
Format” posted on 4/28/2010 at:

http://www.microsoft.com/office/comm...f-a979f6c51058

So far, I’m still looking for an answer, but this post got me closer!


"PieterLinden via AccessMonster.com" wrote:

> Flopbot wrote:
> >I know this might seem technically wrong and therefore, I haven’t found
> >advice on how to do it on these postings. I have an Access 03 table
> >“EventTable1” with fields “StartTime” and “EndTime”. These times are the
> >actual times of our events. I have another table “StaffTable1” with fields
> >”ActualStartTime” and “ActualEndTime”. I want to track all these times in
> >the table and want the actual start/end time fields to default to the
> >start/end time fields. Many times they’ll be the same, but sometimes they
> >won’t. Any simple ways of doing this using the default value in table design?
> >
> >Thank you!
>
> Do it in the form. You can set the defaults using a function or dlookup.
>
> --
> Message posted via http://www.accessmonster.com
>
> .
>