When I use the following Code my report never loads the data it just sits there and thinks.
VB Code:
Set crxDBField = rptStand.Database.Tables.item(4).Fields.item(3) rptStand.RecordSortFields.Add crxDBField, crAscendingOrder
Questions I have are does anything look wrong there? as for tables.ites(4) and fields.item(3) this number starts at 1 not zero correct? so tables.item(4).fields.item(3) will represent the 3rd field in the 4th table correct? I have tried it with the base number of 1 and zero still with the same results.
Any ideas?


Reply With Quote