Solved Dcount on Query

[Sarah.M]

Hi, Plz note, My VBA is blocked by IT for security reason (Cybersecurity).
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
I have EmployeeT and PhoneT
I make Query to show me How many phones does the employee own? this query will be bound with EmployeeF
I got no result and I got this message error
plz help me
Sample Attached

 

[Sarah.M]

The good way if I make the Dcount from Query Filter will work always

 

[bob fitz]

Try the attached db. Post back if you have questions.

 

[Sarah.M]

I did this way but still I got error
CountPhones: DCount("[PhoneT]![PhoneID]","[PhoneT]","=[EmployeeID]=" & [EmployeeIDFK])
CountPhones: DCount("[PhoneT]![PhoneID]","[PhoneT]","[EmployeeID]=" & [EmployeeIDFK])

 

[Sarah.M]

Try the attached db. Post back if you have questions.

Yes this is what I am looking for
Thanks!

 

[bob fitz]

Yes this is what I am looking for
Thanks!

I changed the query used for the form.

 

[Sarah.M]

I changed the query used for the form.

Thanks for your help it work!