From: John W. Vinson on 4 May 2010 12:55
On Mon, 3 May 2010 13:05:01 -0700, deb <deb(a)discussions.microsoft.com> wrote:
>sorry it took so long to answer, I was in class all week.
>The listbox is unbound and the primary key of the listbox's record is
>UnitType (text) some of the options in the list box may be something like...
>or it could be
>and so on
>so if the list box displays:
>Then display the ST form.
What is the listbox's RowSource? What's the point of a listbox which displays
multiple identical records? I don't understand the purpose of this form
control at all!
You can do a Query against a table (or another query) but you can't do a Query
on a listbox. I think you need to take a step back and look at the data
underlying the listbox, not at the listbox itself.
John W. Vinson [MVP]