Sorting Within A Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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]'.
 
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]'.
Click to expand...

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?
 
Hmmmmmmm

It worked.

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



--
Andrew


fredg said:
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]'.
Click to expand...

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?
Click to expand...
 
Back
Top