Sorting Within A Form

[Guest]

Hi,

Relatively new to Access and limited knowledge of VBA....

I have a form (frm_Detail_By_Location) that has many fields on it. The
forms' source is a query (frm_Detail_By_Location).

I want to add a button to the form that will sort the form (while it is
open) based on the field the cursor is in.

The 'Order By' property of the form is set to
'([qry_Detail_By_Location].[Keycode]'.

 

[fredg]

Hi,

Relatively new to Access and limited knowledge of VBA....

I have a form (frm_Detail_By_Location) that has many fields on it. The
forms' source is a query (frm_Detail_By_Location).

I want to add a button to the form that will sort the form (while it is
open) based on the field the cursor is in.

The 'Order By' property of the form is set to
'([qry_Detail_By_Location].[Keycode]'.

Wouldn't the simplest method be to just place the cursor in that field
and then click on the A-Z or Z-A tool button? Or Right-click and
select Sort Ascending or Descending?

 

[Guest]

Hmmmmmmm

It worked.

I tried this earlier with no luck - oh well, thanks.



--
Andrew

Hi,

Relatively new to Access and limited knowledge of VBA....

I have a form (frm_Detail_By_Location) that has many fields on it. The
forms' source is a query (frm_Detail_By_Location).

I want to add a button to the form that will sort the form (while it is
open) based on the field the cursor is in.

The 'Order By' property of the form is set to
'([qry_Detail_By_Location].[Keycode]'.

Wouldn't the simplest method be to just place the cursor in that field
and then click on the A-Z or Z-A tool button? Or Right-click and
select Sort Ascending or Descending?