Solved Access result apperance

When I want to have the WBSElement from entered projectname, it gives a #Size! error.
Would you please guide me through that?
 
Sorry this the code I entered : =DLookUp("WBS";"Projects";"ID = " & Nz([WBSElement];0))
 
How can I relate and write in the code, the fact that each project has a different WBS element?
 
In the table design that stores that field, what is the data type set to?
1642515466896.png
 
Can you simply post up a copy of your database? Remove or anonymise any personnel data
Compact and repair it, then Zip it before uploading.
 
Okay that makes no sense, in the form design have you set a format?
1642585808686.png
 

Users who are viewing this thread

Back
Top Bottom