Liveware Publishing Support Forum

My question is re the properties of the R&R SQL Report Control __in a form in VB6 compared to Access2000____In VB6. as per r&r example supplied with r&r Report works__The rsw32.ocx is in components (not references)__Say the control is named Report1__In Vb code if you enter report1. (the references you expect are displayed,.. eg sortfields + all as per manual.__and if this is used the report is sorted in this order.__Ie in Vb6 all is ok.____BUT>>> In Access 2000__The ocx is added and referenced in the tools->references. __ie there is no "components"__The control is added on a form, and named Report1__In Access 2000 vbcode you enter Report1. ( a much abbreviated subset of items eg...BorderColour Height SetFocus. ie the normal properties of a form control.__ie sortfields is not one of the selections.__If you manually type in report1.sortfields(0) eg it does seem to know about it__ie, it changes the case to SortFields(0)__but when the report is printed, there is no errors but ignores the sortfields(0) command__ie The report is sorted in native report saved order., does not use sorffields(0)______Appreciate any ideas as to the problem.______

I have solved the problem of the sortfields(0) not working.__It was the order in which the report1. commands were entered.__I had the sortfields at the top. ie after __WDir = "c: rordersfor108.rsw"__ __Soon as i put the sortfields as per the sample below, it worked.____WDir = "c: rordersfor108.rsw"__Me!Report1.ReportName = WDir__Me!Report1.Destination = 1__Me!Report1.SortFields(0) = "FOREGO.CATEGORY"__Me!Report1.Action = 1____I still do not get the full commands in the command dropdown in access2000__but i am not too worried about this.____Please ignore this message, all is working ok now.____Thanks Karen______