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!

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

Powerprompts using recordset

Status
Not open for further replies.

vinay17in

Programmer
Sep 19, 2002
9
GB
Hi,

We are creating a multiselect prompt for which data being populated using Recordset (Not creating any dynamo).

Our table from which data is being selecetd in recordset has 400 records but the prompt shows only 100 records.

We have found that even recordset is having 100 records in it by running a for loop like
for(i=0;!rs.EOF;i++)
{
rs.MoveNext();
}
and then printing 'i' gives us the number of records in recordset as 100.

Pl. suggest us why this is happening.

Regards,
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top