UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Record Count In A Subform, Access 2003    
 
   
whdyck
post Jan 11 2017, 11:01 AM
Post#1



Posts: 229
Joined: 20-July 11
From: Winnipeg, MB, Canada


Probably a bonehead question:

I have a subform (fsubUntAsnUnitBookingsCardex) that displays no records when the form (frmUntAsnUnitBookingsCardex) is opened.

However, if I then run the following command from the Immediates window (with no records displayed in the subform):
CODE
?Forms!frmUntAsnUnitBookingsCardex.fsubUntAsnUnitBookingsCardex.Form.count

I get back 33. How is that possible?

How can I get the true record count in this subform?

Thanks.

Wayne
Go to the top of the page
 
DanielPineault
post Jan 11 2017, 11:05 AM
Post#2


UtterAccess VIP
Posts: 5,279
Joined: 30-June 11



See: http://www.devhut.net/2016/08/09/display-t...on-a-main-form/

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...
Go to the top of the page
 
whdyck
post Jan 12 2017, 08:06 AM
Post#3



Posts: 229
Joined: 20-July 11
From: Winnipeg, MB, Canada


Thanks, Daniel.

Is it possible to post the attachment in an Access 2003 format?

Thanks.

Wayne
Go to the top of the page
 
DanielPineault
post Jan 12 2017, 08:50 AM
Post#4


UtterAccess VIP
Posts: 5,279
Joined: 30-June 11



Try the link again, there is now an mdb sample available to you.

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    20th October 2017 - 09:11 AM