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

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

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

Show all headers | View raw

"buckskin" <buckskin@mailinator.com> wrote in message
news:8vklhiFn41U1@mid.individual.net...
>
> This all works - nearly.  I can open the form at the record I require and
> can then navigate the other records.
> But the textbox bound to DateModified now shows #Error.
>
> If I remove that sorting field from the recordsource then it displays ok.
> It's obviously the sorting that screws things up (but I need it sorted).
>
> Is there a quick fix?
>
>

Just realised that in my current position, the code is NOT actually opening
the desired record (it goes to the first one).  If I remove the sorting
field, everything does work but it's sorting on the PK instead of the date.

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next 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