Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: "buckskin" <buckskin@mailinator.com>
Newsgroups: comp.databases.ms-access
Subject: Re: Opening a form to a specific record leads to #error for one field
Date: Fri, 1 Apr 2011 10:25:16 +0100
Lines: 17
Message-ID: <8vlk0oFb2U1@mid.individual.net>
References: <8vklhiFn41U1@mid.individual.net> <kZqdnSwP97MBswjQnZ2dnUVZ_gidnZ2d@earthlink.com>
X-Trace: individual.net ZsS8tgxw82bqguvq1moYGQt0kbNxR45Rh2hS+lGBaoGFDv6GcX
Cancel-Lock: sha1:vdT0jKPig3fTOkHtF4vouosTlZw=
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.2001
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.2001
Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-access:741


"Salad" <salad@oilandvinegar.com> wrote in message
news:kZqdnSwP97MBswjQnZ2dnUVZ_gidnZ2d@earthlink.com...
> >
> >
> Your statement
>    Me.RecordSource = "SELECT report_defs.*, report_defs.Type,
>      report_defs.DateModified FROM report_defs
>
> Why do you select Type and DateModified again.  They should already be
> selected in report_defs.*.
>
> Why are you setting the bookmark prior to code for finding the record?

BTW thanks Salad it all works spiffingly well now!