Re: Insert new record at top of continuous form

Neil,
That's not possible. New records always appear last on any updateable
recordset.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"neilmber" <neilmber@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DF0A874C-F011-49C4-815A-406F6E981E19@xxxxxxxxxxxxxxxx
I have a continuous subform that lists the numerous stages of a process.
The
form is sorted in descending order on a seqence number field. I would
like
the blank new record to appear at the top of the list rather than at the
bottom. Any suggestions.

Thanks.


.

Relevant Pages

  • Re: Main form -subform keeping count
    ... If dispatchdetailsquery contains DispatchID and ContactedWork (Boolean) ... Candia Computer Consulting - Candia NH ... Wanted to tie it to the dcount of the field in the subform call [contacted ...
    (microsoft.public.access.forms)
  • Re: Main form -subform keeping count
    ... Candia Computer Consulting - Candia NH ... I put it in yes-dispatchid is an autonumber and contactedwork a yes/no field ... Wanted to tie it to the dcount of the field in the subform call [contacted ...
    (microsoft.public.access.forms)
  • Re: Trouble with Option Buttons
    ... Use the name of whatever object the GroupDescription will use as it's criteria. ... Candia Computer Consulting. ... "Al Campagna" wrote: ...
    (microsoft.public.access.formscoding)
  • Re: Main form -subform keeping count
    ... Private Sub cbotruck_AfterUpdate ... Candia Computer Consulting - Candia NH ... Wanted to tie it to the dcount of the field in the subform call [contacted ...
    (microsoft.public.access.forms)
  • Re: Go to the specified form
    ... Candia Computer Consulting - Candia NH ... But when I double click in this field, just opens a empty record of the ... What you're doing is what I call a "Jump" field. ...
    (microsoft.public.access.forms)