Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

counting records in recordset

Status
Not open for further replies.
rhoenig1277

rhoenig1277

Programmer
Nov 21, 2002
24
US
How can I get the total count of the records returned in a recordset? I'm sending the parameters of the query in a form load routine. I would the like to know how many records were returned so I can populate a list box with the records.
 
Sort by date Sort by votes
HI

I am not sure if this is what you are looking for but it works for me...

howmany = Forms![Quotes Listing].RecordsetClone.RecordCount

I hope that's it
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
753
Andrzejek
Andrzejek
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
1K
Kennelbloke
Kennelbloke
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
706
PrimoSteve
PrimoSteve
Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
457
Xavierparkash
Xavierparkash
Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
3K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top