Control not associated with a table field

[Rouslan]

I'm trying to create an option group (those round controls) that will sort a continuous form based on the option selected, but it seems a control doesn't respond to user input if it's not associated with a table field. Is there an elegant (as apposed to adding an unnecessary field to a table) way to make it respond.

 

[Remou]

The control should respond to an order by, without being bound to a field. Perhaps you could try something like this:

Private Sub [i]FrameName[/i]_Click()
Select Case [i]FrameName[/i]
Case 1
  Me.OrderBy = "Field1"
  Me.OrderByOn = True
Case 2
  Me.OrderBy = "Field2, Field3"
  Me.OrderByOn = True
End Select
End Sub

 

[Rouslan]

It didn't work. The FrameName_Click() event doesn't fire unless the frame itself is clicked.


Also it doesn't matter but when I said sort, I meant filter.

 

[Remou]

I wonder why? I am using Access 2000 and the click event fires when I choose an Option from an unbound Option Group. What version are you using?

 

[Rouslan]

I'm using the same version.

 

[TheAceMan1]

How are ya Rouslan . . .

In the [blue]AfterUpdate[/blue] event of the [blue]option group frame[/blue], copy/paste the fiollowing:

[blue]   Me.OrderBy = Choose(Me![purple][b]FrameName[/b][/purple], "FieldName1", _
                                     "FieldName2", _
                                     "FieldName3", _
                                     "FieldName[purple][b]N[/b][/purple]")
   Me.OrderByOn = True[/blue]

See Ya! . . . . . .

 

[Rouslan]

Kick me. Just kick me really hard. My whole problem was I had "Allow Edits" set to no. Sorry about this.

 

[Remou]

Is it ok to grin?

 

[Rouslan]

Go nuts.