bruceblack
Registered User.
- Local time
- Today, 22:05
- Joined
- Jun 30, 2017
- Messages
- 119
Hey guys! Hope you can correct some syntax here. Im a bit lost.
I have a continuous form.
I have a query with a (count) field which i want to display on the form
So i do a Dlookup to get the value. Problem is, it only should do the counting for that specific ID.
I was trying this:
So im using ID 2 times, i know. Maybe thats the issue? I get Error in my form field
Hope you guys get what im trying to do. Thanks in advance!
I have a continuous form.
I have a query with a (count) field which i want to display on the form
So i do a Dlookup to get the value. Problem is, it only should do the counting for that specific ID.
I was trying this:
Code:
=DLookUp("[ID]";"[major_count]";"[ID] = Me![ID]")
So im using ID 2 times, i know. Maybe thats the issue? I get Error in my form field
Hope you guys get what im trying to do. Thanks in advance!