Toggle Buttons to Update List Box

[weilerdo]

Hi All, I have a project that I need help with. I'm trying to recreate a form from a Borland dB3 database. I was able to find code from the Northwind database to do the toggle buttons on a form. I can get it to work fine as long as its a single form and only displaying 1 record at a time. What I need is for it to have a Listbox on the left side showing all records and if they select one of the toggle buttons ( IE A-Z the listbox on the left should update to only showing records that start with that letter. Any help would be greatly appreciated on this. Thank you in advance for looking at this.

I have attached a copy of the form and a screen shot of what I need it to look like.

 

[pbaldy]

Personally I would probably use a textbox and type a letter (or letters), because I don't like using all that screen real estate for 26 buttons. Either way you can use a similar technique though. For your buttons:

Me.ListBoxName.RowSource = "SELECT Blah FROM TableName WHERE FieldName Like 'A*'"