Re: vertical ordering of continuous form

From: Steve Schapel (schapel_at_mvps.org.ns)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 20:02:11 +1200

Daniel,

This can't be done directly in a continuous view form. One way to get
this result, is to put your continuous form as a subform on another
(probably unbound) form. Set its Allow Additions property to No, so the
"blank" record doesn't appear at the bottom. Then, make a copy of the
continuous form, but make it in single view, so only one record shows,
and set its Data Entry property to Yes. Then, put this also as a
subform, right above your continuous subform. If you like, with a bit
of fiddling, you can make it look like it is a blank record at the top
of the continuous subform. And then, on the After Update event of this
second subform, put code to move to a new record, and Requery the
continuous subform so the newly added record is shown on the continuous
subform. Hope that makes sense. 

-- 
Steve Schapel, Microsoft Access MVP
Daniel wrote:
> Hello,
> 
> by default with a continuous form the data scrolls vertically in a downwards 
> direction with the empty field for data entry at the very bottom of the list. 
>  Is there a way to make it so that the data entry field (blank field) would 
> be at the top, thus avoiding the user from scrolling through the existing 
> entries?
> 
> Thank you,
> 
> Daniel

Relevant Pages

  • Re: vertical ordering of continuous form
    ... It made perfect sense! ... > continuous form, but make it in single view, so only one record shows, ... > subform, ... > Daniel wrote: ...
    (microsoft.public.access.forms)
  • Re: new record is automatically added to continuous subform... how do I stop?
    ... A continuous form ... this is an Audit record application that allows the user to enter ... I'm not actually trying to "create an interface that noone would ... When you create a new record in your main form, the subform will ...
    (microsoft.public.access.forms)
  • Re: Subform trouble for New User
    ... I> added that field to the query used to generate the subform, but the> result was that instead of getting a continuous form with all> operator log entries, it was limited to the log entries corresponding> to the specific shift identified by the tblLog_ID field. ... The structure of this tab is> three fields that identify the date, shift, and operator name along> with a continuous subform that uses multiple lines to provide detail> for a full log entry. ... The other tab has a subform set up as a> continuous form.I have limited the fields in the continuous form to> fit on one line. ...
    (microsoft.public.access.forms)
  • Re: new record is automatically added to continuous subform... how do I stop?
    ... this is an Audit record application that allows the user to enter ... I'm not actually trying to "create an interface that noone would ... continuous form. ... When you create a new record in your main form, the subform will normally ...
    (microsoft.public.access.forms)
  • Re: Table Fields: conditional values based on another field in same ta
    ... Locking/Unlocking/displaying the controls on the subform by changing ... This is not successful on a continuous form. ... Exempt Reason (3 values in value list: ...
    (microsoft.public.access.tablesdbdesign)