Hi,
The current event of my form counts the record in the recordset, and then if there is only one record, it runs another code. I have the code as follows.
if DCount("*", "tblMytable")=1 then
.......
I need a similar code to count the record while the filter is on. And if the record count of the current filter is 1 then it should run the same code.
Can someone help please.
Thanks in advance.