Using an option group to populate a list box

[rottweiller]

If a have an option group with letters A - Z and All. How can i click on say 'A' and get all the names starting with 'A' displayed in the list box in ascending order

[debasisdas]

If retriving name s form database then use the LIKE search to populate the list.

[code=oracle]select name from table_name where upper(name) like ('A%') order by name;[/code]

need to do the same for all the option buttons and dynamically assign the search criteria.

[rottweiller]

If retriving name s form database then use the LIKE search to populate the list.

[code=oracle]select name from table_name where upper(name) like ('A%') order by name;[/code]

need to do the same for all the option buttons and dynamically assign the search criteria.

Sorry for not mention what program i was using. I am using Ms Access