Solved Access result apperance

[Springblossom]

When I want to have the WBSElement from entered projectname, it gives a #Size! error.
Would you please guide me through that?

 

[Springblossom]

Sorry this the code I entered : =DLookUp("WBS";"Projects";"ID = " & Nz([WBSElement];0))

 

[Minty]

I don't know why I got a calender next to it.

It thinks it's a Date field. What is the datatype in the table?

 

[Springblossom]

it looks like this: BBUK-17-5999

 

[Springblossom]

How can I relate and write in the code, the fact that each project has a different WBS element?

 

[Minty]

In the table design that stores that field, what is the data type set to?

 

[Springblossom]

I can't see any data type in the design table.

 

[Minty]

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.

 

[Springblossom]

I will try to do so.

 

[Springblossom]

In the table design that stores that field, what is the data type set to?
View attachment 97619

It is short text.

 

[Minty]

Okay that makes no sense, in the form design have you set a format?