M
Mike Painter
Here is a routine I've used from time to time when there is a small list to
select from. It works the way many events can be set. I usually put it in
the on click event
While it can be used for any number of items, three or maybe four is about
optimum, after that a combo or list box is probably better.
Select Case Me!somefield
Case "yes"
Me!somefield = "no"
Case "no"
Me!somefield = "maybe"
Case "maybe"
Me!somefield = "yes"
End Select
select from. It works the way many events can be set. I usually put it in
the on click event
While it can be used for any number of items, three or maybe four is about
optimum, after that a combo or list box is probably better.
Select Case Me!somefield
Case "yes"
Me!somefield = "no"
Case "no"
Me!somefield = "maybe"
Case "maybe"
Me!somefield = "yes"
End Select