List Box On Form - Toggle to Limit Record Selection

[razorking]

Hello,

I have a form that uses a list box to display records and a search functionality. I am wondering if there is a way to have a toggle button on this form that would use the field status. Meaning: is there a way to have a toggle button that would toggle between a view of all projects are just those that are status Open or Awarded?

Thanks! (see attached example)

 

[boblarson]

In the After Update event of the toggle button:

If Me.ToggleButtonName = True Then
   Me.Filter = "[Status]='Awarded'"
   Me.Caption = "Awarded"
Else
   Me.Filter = "[Status]='Open'"
   Me.Caption = "Open"
End If
   Me.FilterOn = True

 

[boblarson]

I couldn't look at the example because I don't have 2007 at work so it was just code I can provide.

 

[razorking]

Bob,

A couple things:

1) I would hate to go back to earlier versions of Access after using 2007. If at all possible check it out. Especially given your abilities - you should have it.

2) I understand your solution. On the same subject; is there a way to show records that are open or Awarded - with one toggle, and then all records with the other toggle?

3) I have attached a 2003 version

 

[boblarson]

Well, I appreciate the attempt with the 2003 version but I keep getting an error when trying to save and I can't do anything with it. I tried importing into a new database too but that didn't work. I'll probably have to deal with the 2007 version when I get home.

 

[razorking]

I have not been able to get this to work. Maybe it is not possible?

I have re-attached a 2000 version of the db.