Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.ms-access > #741

Re: Opening a form to a specific record leads to #error for one field

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 2011-04-01 10:25 +0100
Message-ID <8vlk0oFb2U1@mid.individual.net> (permalink)
References <8vklhiFn41U1@mid.individual.net> <kZqdnSwP97MBswjQnZ2dnUVZ_gidnZ2d@earthlink.com>

Show all headers | View raw


"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!

Back to comp.databases.ms-access | Previous | NextPrevious in thread | Find similar | Unroll thread


Thread

Opening a form to a specific record leads to #error for one field "buckskin" <buckskin@mailinator.com> - 2011-04-01 01:45 +0100
  Re: Opening a form to a specific record leads to #error for one field "buckskin" <buckskin@mailinator.com> - 2011-04-01 02:13 +0100
  Re: Opening a form to a specific record leads to #error for one field Salad <salad@oilandvinegar.com> - 2011-03-31 20:47 -0500
    Re: Opening a form to a specific record leads to #error for one field "buckskin" <buckskin@mailinator.com> - 2011-04-01 05:19 +0100
      Re: Opening a form to a specific record leads to #error for one field Salad <salad@oilandvinegar.com> - 2011-04-01 07:52 -0500
    Re: Opening a form to a specific record leads to #error for one field "buckskin" <buckskin@mailinator.com> - 2011-04-01 10:25 +0100

csiph-web