From: John W. Vinson on
On Sat, 23 Jan 2010 21:54:24 -0700, "CJ" <private(a)newsgroups.com> wrote:

>The SQL you gave me works, Thanks! Except that if I look up an existing
>record, the previously selected products are not showing up in the combo
>field
>they are blank.

ummmm... exactly.

That way the user cannot select it twice.

--

John W. Vinson [MVP]
From: CJ on
OK then.

I will just capture the product so that they have a record of what was
selected.

Thanks John!

--
Thanks for taking the time!

CJ
---------------------------------------------------------
Know thyself, know thy limits....know thy newsgroups!
"John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message
news:epsnl510htl3ae7o18ur5vpvcreoesro4o(a)4ax.com...
> On Sat, 23 Jan 2010 21:54:24 -0700, "CJ" <private(a)newsgroups.com> wrote:
>
>>The SQL you gave me works, Thanks! Except that if I look up an existing
>>record, the previously selected products are not showing up in the combo
>>field
>>they are blank.
>
> ummmm... exactly.
>
> That way the user cannot select it twice.
>
> --
>
> John W. Vinson [MVP]