ashwinghanta
Board Regular
- Joined
- Dec 6, 2011
- Messages
- 118
I have a form in Access which sorts queries with start date and end date. There are 4 different buttons A,B,C,D which have 4 textboxes beside them. Each of these button runs a query within the stipulated dates. I made another query named Count which counts the records in all the 4 queries. It has 4 fields named FieldA, FieldB, FieldC and Field D.
I made this Count query as the Record Source of the form and I added the fields FieldA, FieldB, FieldC, FieldD into the 4 text boxes. When I turn back into Form View or when I refresh the form the 4 textboxes are filled with <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; background-color: rgb(239, 240, 241); white-space: pre-wrap;">0 as a value</code>. Although in the Count Query their values are <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; background-color: rgb(239, 240, 241); white-space: pre-wrap;">20, 25, 56, 97</code>.
What could be the possible reason for it not to work? Why are the values not shown in the textboxes?
I made this Count query as the Record Source of the form and I added the fields FieldA, FieldB, FieldC, FieldD into the 4 text boxes. When I turn back into Form View or when I refresh the form the 4 textboxes are filled with <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; background-color: rgb(239, 240, 241); white-space: pre-wrap;">0 as a value</code>. Although in the Count Query their values are <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; background-color: rgb(239, 240, 241); white-space: pre-wrap;">20, 25, 56, 97</code>.
What could be the possible reason for it not to work? Why are the values not shown in the textboxes?