From: John W. Vinson on 24 Jan 2010 02:14 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 24 Jan 2010 16:42 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]
First
|
Prev
|
Pages: 1 2 Prev: Records and Associated Notes Query Next: loan or RD deduction using dtpicker |