Default to data in a different table?

[Flopbot]

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!

 

[Flopbot]

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/com...orms&mid=7ffd8a5a-24f4-4087-aa4f-a979f6c51058

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