Return # of Records from Query
Posted on 2014-12-05
I have a form that has
I have a query that has these two fields with this in the two fields respectively:
[Forms]![Copy Of QRY_MG_3055-1]![Inspected]
[Forms]![Copy Of QRY_MG_3055-1]![DateEntered]
I have a button to click Run Query
I want a field on my form to return the total number of Records the Query comes up with.
right now the query comes up and I don't want that anymore....I just want a field to be hidden and then visible when the button is clicked to reveal the # of records.
Any help is appreciated...