Sorting in a subform?

[Kysteratwork]

Hi All,

I have a subfrm (continuous form) where I would like to create a command button that sorts the entire subform by the text field txtCompany... sounds easy enough, but I don't know how to do that. Is it at all possible in a form?

Thank you in advance for any indication.

Kysteratwork

 

[kysterathome]

Zameer, it gives me the error message:

Compile Error: Method or data Member not found.

and .subfrmTransactions is highlighted (in Me.subfrmTransactions.SetFocus ). The name is correct, though.

?

 

[PHV]

And this ?
Me!subfrmTransactions.SetFocus

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ZmrAbdulla]

I believe you are using the command button on the mainform. I tried this and worked perfect.
It is not necessary your subform name and subform control in the main form hold the same name.
Also try
Me!subfrmTransactions.SetFocus

Zameer Abdulla
JVBP MDS
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[kysterathome]

Zameer,

Now I get:
Can't find the field subfrmTransaction you refer to in your expression. But if it works fine with you, there must be a mistake somewhere that I haven't seen. I will keep trying!

Thank you for your efforts!

Kysterathome

 

[PHV]

Is subfrmTransactions the name of the control hosting the subform ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Kysteratwork]

PHV, that was indeed a problem, but now the error message reads:

The command or 'SortAscending'isn't available now.

....