KeemoSabby
New member
- Local time
- Today, 04:03
- Joined
- Sep 9, 2021
- Messages
- 4
I have a form with a sub form table whose values I need to track in text boxes in real-time
basically, I want to set the value of the text boxes with the value from CountIf( fieldbool = true ) from one field, and series of boxes with Countif(fieldx= constant) with a different text box per constant. This needs to be done after each insert in the subform
here is the core query I need to be tracked (the others are all similar, string comparisons from a dropdown box):
SELECT Count(Songs.Cancon) AS CountOfCancon
FROM Logger INNER JOIN Songs ON Logger.Logger_ID = Songs.Logger_ID
HAVING (((Count(Songs.Cancon))=True));
Thanks for any advice
basically, I want to set the value of the text boxes with the value from CountIf( fieldbool = true ) from one field, and series of boxes with Countif(fieldx= constant) with a different text box per constant. This needs to be done after each insert in the subform
here is the core query I need to be tracked (the others are all similar, string comparisons from a dropdown box):
SELECT Count(Songs.Cancon) AS CountOfCancon
FROM Logger INNER JOIN Songs ON Logger.Logger_ID = Songs.Logger_ID
HAVING (((Count(Songs.Cancon))=True));
Thanks for any advice
Last edited: