C cheer Registered User. Local time Today, 08:35 Joined Oct 30, 2009 Messages 222 Mar 6, 2010 #1 How to write a VBA to determine a subform whether has data or not ?
V vbaInet AWF VIP Local time Today, 00:35 Joined Jan 22, 2010 Messages 26,328 Mar 6, 2010 #2 You can count the recordset of the subform. You can also use the DCount function. Have a look at that.
You can count the recordset of the subform. You can also use the DCount function. Have a look at that.
C cheer Registered User. Local time Today, 08:35 Joined Oct 30, 2009 Messages 222 Mar 6, 2010 #3 vbaInet said: You can count the recordset of the subform. You can also use the DCount function. Have a look at that. Click to expand... I know DCount, how to count the recordset of the subform? Don't mind to show simple VBA code here.
vbaInet said: You can count the recordset of the subform. You can also use the DCount function. Have a look at that. Click to expand... I know DCount, how to count the recordset of the subform? Don't mind to show simple VBA code here.
V vbaInet AWF VIP Local time Today, 00:35 Joined Jan 22, 2010 Messages 26,328 Mar 6, 2010 #4 If you say you know the DCount function then you can apply it to count the number of records in the subform. It's the same thing as counting the recordset if used with the right arguments.
If you say you know the DCount function then you can apply it to count the number of records in the subform. It's the same thing as counting the recordset if used with the right arguments.
