Adele,
I copied your code into the program and it works. Since my
code is somewhat simpler, is there a reason to use the more
complex code that I should know about?
DRG
>From: "Adelle Hartley" < adelle%40akemi.com.au">adelleakemi.com.au> >Reply-To: helpwithvb%40yahoogroups.com">helpwithvbyahoogroups.com
>To: < helpwithvb%40yahoogroups.com">helpwithvbyahoogroups.com>
>Subject: RE: [helpwithvb] "Findfirst" in DAO
>Date: Thu, 11 Oct 2007 16:28:42 +1000
>
>Donald Gaither >
> > I'll be glad to, but I can't imagine that I know something
> > that youall would find useful. The command that worked
> > was:
> >
> > rsApmst.FindFirst "Vendor = '" & Glkup1$ & "'"
>
>You want to change that to
>
>rsApmst.FindFirst "Vendor = '" & Replace$(Glkup1$, "'", "''") & "'"
>
>Trust me.
>
>Adelle.
>
> I copied your code into the program and it works. Since my
> code is somewhat simpler, is there a reason to use the more
> complex code that I should know about?