Default values dependant on another entry

[Mark Baker]

I have a time tracking database that we use in our office. People generate
time cards, each timecard has a subform that they enter the time in. In this
suform they enter a date, the project name and a workcode. 99% of the time
the work code can be defaulted depending on the project. I have added a
defaultworkcodeID feild in the Projects table. Now what i need to do is
figure the best way to make the workcode entry to look up tthe project name
they entered. I have tried a DLookup in the default property but it leaves
the cell blank .

 

[Jeff Boyce]

Mark

If your [Projects] table already holds the Project and a
[defaultworkcodeID], why do you feel you need to store that
[defaultworkcodeID] a second time, in a new table (re: time tracking)?

If you know the project, don't you also know the workcode?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.