Can I apply 3 results to one radio button?

I have an option group with 2 radio buttons that will filter my query.

1 - Retail - This option needs to be all records for 3 different customers - 123 and 456 and 789

2 - Wholesale - This will select customer #123456 only

I cannot figure out how to write the VBA for option 1 to include all 3.

Private Sub optSoldTo_AfterUpdate()
Select Case Me!optSoldTo
Case 1
Me!txtSoldTo = "123" Or "456" Or "789"
Case 2
Me!txtSoldTo = "123456"
End Select

End Sub

Thanks!



Toni