Default Value

[M.A.Halim]

I have a table "Positions" that has 2 fields (Job Code) and (Positions) that
is feeding another table "Employees Data" through a lookup, in which I need
to set the default value of the (Job Code) Field in the "Employees Data" to
pick up automatically the (Job Code)based on the choice of the position. I
Tried the following formula but not working. =DLookup("[Job Code]",
"[Positions]", "[Position] = Tables![Position]")

Thanks

 

[Jeff Boyce]

If you are saying that knowing the [Position] automatically determines the
[Job Code], then why bother?

You don't need to (redundantly) store "derivative" data if you could simply
use a query (and a join) to derive [Job Code] from [Position] ... just store
[Position]!

Or am I missing something...?

Regards

Jeff Boyce
Microsoft Office/Access MVP