Re: Detail Form Scroll After Insert Record

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Gary,

Because the form contains details of item, so it should be viewed in
continuous form.
Actually, the form has enough height to display completely around 5 lines
of item.
Thanks.


"Gary Miller" <gmillerNO@xxxxxxxxxxxxxxxxxxx> wrote in message
news:#L3KcnOEGHA.2704@xxxxxxxxxxxxxxxxxxxxxxx
> Vensia,
>
> Is it possible that your subform is set to SingleForm
> instead of ContinuousForms? Check the DefaultView property
> of the subform in its design view.
>
> It sounds like either that is the problem or your subform
> container is not long enough to display multiple records.
>
> --
> Gary Miller
> Sisters, OR
>
>
>
> "Vensia" <vensia2000_nospam@xxxxxxxxx> wrote in message
> news:O23SToNEGHA.3728@xxxxxxxxxxxxxxxxxxxxxxx
> > Dear all,
> >
> > I put the following code at After_Update event of
> > frmInvoiceDetail
> >
> > Dim rs As DAO.Recordset
> > Dim strSQL As String
> > Dim curTotalAmount As Currency
> >
> > strSQL = "SELECT * FROM tblInvoiceMain WHERE InvoiceNo =
> > '" &
> > Me!InvoiceNo & "'"
> > curTotalAmount = Nz(DSum("Amount", "tblInvoiceDetail",
> > "InvoiceNo = '" &
> > Me!InvoiceNo & "'"), 0)
> > Set rs = CurrentDb.OpenRecordset(strSQL)
> > With rs
> > .Edit
> > !TotalAmount = curTotalAmount
> > !Tax = !TotalAmount * 0.1
> > .Update
> > End With
> > rs.Close
> > Set rs = Nothing
> >
> > Every time after I insert a new line of item, the Detail
> > Form
> > (frmInvoiceDetail) will scroll and at the screen, I just
> > can see the new
> > record. I should use the vertical scroll to see the
> > existing lines of item
> > Why this happens ?
> > Thanks.
> >
> > Vensia
> >
> >
>
>


.

Relevant Pages

  • Re: SubForm in Datasheet View
    ... A datasheet view is not just a different looking kind of continuous form. ... You can't display lots of things on a datasheet. ... You'll have to live with continous form in your subform or do without the ...
    (comp.databases.ms-access)
  • Display images that change in the detail field of a subform
    ... I am trying to create a subform that will display images related to the ... The subform is a continuous form as there will be several ...
    (comp.databases.ms-access)
  • Re: Increase the amount of records shown in a continuous form
    ... Then you'll need to use a subform to display the actual records. ... >> <MS ACCESS MVP> ... >>> a continuous form? ...
    (microsoft.public.access.formscoding)
  • Attempting to add reformatted data to a subform
    ... This pulls data from tables and attempts to reformat it to display more ... to have the subform display the data from the new table. ... Dim frmForm As Access.Form ... 'tbldefForms has been put together and completed. ...
    (microsoft.public.access.formscoding)
  • Re: Display Details Once
    ... also some text that i want to display below the records but only appear once ... Might it be possible to have the continuous Form as a Subform? ... John W. Vinson ...
    (microsoft.public.access.forms)