bruceblack
Registered User.
- Local time
- Today, 03:48
- Joined
- Jun 30, 2017
- Messages
- 119
Hi folks! Please can someone help me out?
I have a form that i use to display query data.
In the control source of a form field, i do a Dlookup to get the value from the query. However, no result shows up, instead the form field is flickering like crazy.
The code i used on the form field control source:
=DLookUp("[CountOfitem_ID]","[ASV_itemcount TOTAL]")
Note: the ASV_itemcount TOTAL query is result of another query. It only has 1 value.
I have a form that i use to display query data.
In the control source of a form field, i do a Dlookup to get the value from the query. However, no result shows up, instead the form field is flickering like crazy.
The code i used on the form field control source:
=DLookUp("[CountOfitem_ID]","[ASV_itemcount TOTAL]")
Note: the ASV_itemcount TOTAL query is result of another query. It only has 1 value.