Program a list box

[Seahawk via AccessMonster.com]

I have a list box that looks up all the names in a table, EX: 'Smith,Joe',and
puts them in alphabetical order.

Is it possible to only pull up the names that begin with the letters, say A-
F only, to display in the list?

 

[Duane Hookom]

Your list box has a Row Source property which is generally a query. You can
change the Row Source property to something like:
SELECT FullName
FROM tblNoNameProvided
WHERE FullName Between "A" AND "FZ"
ORDER BY FullName;

 

[Seahawk via AccessMonster.com]

Very Nice. Worked Perfect.
Thank You very much

Your list box has a Row Source property which is generally a query. You can
change the Row Source property to something like:
SELECT FullName
FROM tblNoNameProvided
WHERE FullName Between "A" AND "FZ"
ORDER BY FullName;

I have a list box that looks up all the names in a table, EX:
'Smith,Joe',and

[quoted text clipped - 3 lines]

A-
F only, to display in the list?