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: 224
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: 4,948
Joined: 30-June 11



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

--------------------
Daniel Pineault (2010-2016 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".
* A user interface is like a joke, if you have to explain it, it's not that good!
Go to the top of the page
 
whdyck
post Jan 12 2017, 08:06 AM
Post#3



Posts: 224
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: 4,948
Joined: 30-June 11



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

--------------------
Daniel Pineault (2010-2016 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".
* A user interface is like a joke, if you have to explain it, it's not that good!
Go to the top of the page
 
« Next Oldest· Access Forms· Next Newest »
 
Display Mode: Switch to: Standard · · Switch to: Outline

Track this topic ·Email this topic · Print this topic · Subscribe to this forum

Custom Search
RSSSearch   Top   Lo-Fi    27th June 2017 - 03:46 PM