R
Robert5833
Good day all;
There’s probably a very simple fix/solution for my issue, but after hours of
searching and reading in the discussion group here, such a solution eludes me.
I have a form with an unbound text box where a key word can be entered for
text searching of stored records in a table. From the form’s module the value
in the unbound text box is passed to a separate module, which then builds an
SQL string and returns those values to the form’s sub.
All of that works fine, and all I want to do is *display the number of
records returned* by the SQL string in another unbound text box on the form.
(This is to show the user; me, how many records are available to scroll
through; 1 or 10,000, so maybe the keyword search should be narrowed or
expanded, etc.)
As always; I appreciate any help/suggestions you may offer.
Best regards
There’s probably a very simple fix/solution for my issue, but after hours of
searching and reading in the discussion group here, such a solution eludes me.
I have a form with an unbound text box where a key word can be entered for
text searching of stored records in a table. From the form’s module the value
in the unbound text box is passed to a separate module, which then builds an
SQL string and returns those values to the form’s sub.
All of that works fine, and all I want to do is *display the number of
records returned* by the SQL string in another unbound text box on the form.
(This is to show the user; me, how many records are available to scroll
through; 1 or 10,000, so maybe the keyword search should be narrowed or
expanded, etc.)
As always; I appreciate any help/suggestions you may offer.
Best regards