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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subscript out of range

Status
Not open for further replies.

rtshort

IS-IT--Management
Feb 28, 2001
878
US
I am calling a recordset from a database and loading it into a flexgrid. After the flexgrid is loaded the user can select an item and click "add" and it is added to another flexgrid(invoice).

The first 2 or 3 items load fine and the next gives the "subscript out or range" error.

The information comes from the same database and uses the same code. What an I doing wrong?? Every day above ground is a GOOD DAY!!!
 
Are you changing .ROWS as you go along.
The "subscript out or range" error is usually given for an array.
You did not say how you add a new row.
You should bew able to Step through it in Debug Mode.
 
You're right on target John. I wasn't counting the .RowSel
I was not using the .RowSel -1
Thanks for taking time to answer. Every day above ground is a GOOD DAY!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top