Index Problem

[ApexData]

My table has 3-fields

No Primary Index.

FIELDA Index(yes Dupes OK), Required NO
FIELDB Index(yes NoDuplicates), Required YES
FIELDC NoIndex

I placed the following code in the OnLoad Event of a continuous form:
Me.OrderBy = "FIELDSORT"
Me.OrderByOn = True

I want FIELDA to be the main index and FIELDB to be secondary.
But the index insists on being FIELDB. Why???

Thanks Greg

[Rick Brandt]

<Ap******@gmail.comwrote in message
news:11**********************@a75g2000cwd.googlegr oups.com...

My table has 3-fields

No Primary Index.

FIELDA Index(yes Dupes OK), Required NO
FIELDB Index(yes NoDuplicates), Required YES
FIELDC NoIndex

I placed the following code in the OnLoad Event of a continuous form:
Me.OrderBy = "FIELDSORT"
Me.OrderByOn = True

I want FIELDA to be the main index and FIELDB to be secondary.
But the index insists on being FIELDB. Why???

What is "FIELDSORT"? If you want to sort on FieldA then FieldB use that in the
OrderBy...

Me.OrderBy = "FIELDA, FIELDB"
Me.OrderByOn = True

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[ApexData]

Sorry

I placed the following code in the OnLoad Event of a continuous form:
Me.OrderBy = "FIELDA"
Me.OrderByOn = True

This did not work!

[Rick Brandt]

<Ap******@gmail.comwrote in message
news:11**********************@q2g2000cwa.googlegro ups.com...

Sorry

I placed the following code in the OnLoad Event of a continuous form:
Me.OrderBy = "FIELDA"
Me.OrderByOn = True

This did not work!

Clarify "did not work". Does your form's RecordSource have a field named
"FIELDA"?

I though you wanted to sort on both FIELDA and FIELDB?
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[ApexData]

Rick

Thanks for your response.
I do want to sort by 2-Fields, but to simplify - have been attempting
a single field first.

I have assigned the Forms value by code:
[Forms]("FL-FIELDEDIT2").RecordSource = strTable
The data shows just fine, but the data sort is only on the FIELDB.
Despite the Me.OrderBy = "FIELDA" and the Me.OrderByOn = True in the
OnLoad
event of the form.

I wonder if the Table indexes I mentioned are over-riding my effort?

Greg

[ApexData]

Rick

I figured it out:

[Forms]("FL-FIELDEDIT2").RecordSource = strTable
[Forms]("FL-FIELDEDIT2").OrderBy = "FIELDA, FIELDB"

I was setting the OrderBy too late. After my subform arrived.
Sorry for the vague question. It wasn't easily described.

Greg