weightinwildcat
Programmer
Hi. I am using DoCmd.OpenForm to open an ORDERS form from another form, as follows:
DoCmd.OpenForm ORDERS,,,filter,,
The filter in this case is "OrderNumber = " & Me.OrderNumberBox.Value
Once this happens, I am trying to use Set rs = Me.RecordSet, and then get a count of the number of records using rs.RecordCount; however, the record count always comes up as zero, even when the calling form shows records. Can somebody suggest a fix or a workaround?
Thank you in advance.
DoCmd.OpenForm ORDERS,,,filter,,
The filter in this case is "OrderNumber = " & Me.OrderNumberBox.Value
Once this happens, I am trying to use Set rs = Me.RecordSet, and then get a count of the number of records using rs.RecordCount; however, the record count always comes up as zero, even when the calling form shows records. Can somebody suggest a fix or a workaround?
Thank you in advance.