Need query to separate 2 entry types in a table field

Jan,

The Case statements will refer to the Option Value of the Option Button
that you select in the Option Group. Enough options for you? Look at
the properties of each of the Option Buttons, and see if the Option
Value property is set to 1, 2, and 3 respectively for the 3 of them.

--
Steve Schapel, Microsoft Access MVP

Jan Il wrote:
Hi Steve :-)


'k..!! Now here's what I now have, and the Debugger's happy with it.

Private Sub fmeOptionGrp_AfterUpdate()
Select Case Me.fmeOptionGrp

Case 1
Me.RecordSource = "SELECT * FROM qryCkRegisterDan WHERE CheckNo Not
Like 'DBT*'"
Case 2
Me.RecordSource = "SELECT * FROM qryCkRegisterDan WHERE CheckNo
Like 'DBT*'"
Case 3
Me.RecordSource = "qryCkRegisterDan"
End Select

End Sub


YES!!!

But.....ahmmm......nothing happens when I click the buttons. (?..?) It
looks really nice though. :-)

What might I have left out? Do I need a command button to go with?

Jan