Having problems using OrderBy property after DoCmd.OpenForm

[bell]

Hi All,



I am doing something wrong, and I cant figure it out

I have a form "Wirelist Cover Form", and I use a button click to open another form "Wirelist Form" as so

stDocName = "Wirelist Form"
stLinkCriteria = "[Document Number] = '" & Me![Document Number] & "'" & " AND [Revision] = '" & Me![Revision] & "'"
DoCmd.Close acForm, "Wirelist Cover Form"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Now, I want to order the "Wirelist Form" by the field "Wire" because I have noticed that sometimes the wires do not show up in order.

One problem is, the "Wirelist Form" has a subform "Wirelist subform" where the wires are actually displayed.

Now, I thought I could use the OrderBy property after using the Open Form like

Forms![Wirelist Form]![Wirelist subform].OrderBy = "[Wire]"
Forms![Wirelist Form]![Wirelist subform].OrderByOn = True

But I get the error "Object doesn't support this property or method"

Can someone help me figure out what the correct way is to sort these wires?

[bell]

Well nevermind, I instead used the subforms Open event to do

Me.OrderBy = "[Wire]"
Me.OrderByOn = True

Still a little confused why my other code wouldnt work, but I guess it doesnt matter now

[John_G]

Glad you got it to work.

Subforms are not part of the Forms! collection, even when they are open, so you cannot refer to them that way. (Forms![Wirelist Form]![Wirelist subform].OrderBy = "[Wire]").

What you have to do is use the name of the subform container control on the main form, and then refer to the subform within it. For example, let's assume you names the subform control (on the main form) sfrmContainer.

Your expressions would now look like this:

Forms![Wirelist Form]![sfrmContainer].form.OrderBy = "[Wire]"
Forms![Wirelist Form]![sfrmContainer].form.OrderByOn = True

[bell]

Glad you got it to work.

Subforms are not part of the Forms! collection, even when they are open, so you cannot refer to them that way. (Forms![Wirelist Form]![Wirelist subform].OrderBy = "[Wire]").

What you have to do is use the name of the subform container control on the main form, and then refer to the subform within it. For example, let's assume you names the subform control (on the main form) sfrmContainer.

Your expressions would now look like this:

Forms![Wirelist Form]![sfrmContainer].form.OrderBy = "[Wire]"
Forms![Wirelist Form]![sfrmContainer].form.OrderByOn = True

Ohh okay thank you!