Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

RE: Number of records in a subform

Discussion in 'Information Technology' started by rg, Jul 28, 2006.

  1. rg

    rg
    Expand Collapse
    Guest

    Thanks. I've been trying to understand the Me, but it still seems vague.
    Could you please give me an explanation of what it is exactly?

    "Ofer Cohen" wrote:

    > Try
    >
    > Me.SubFormName.Form.RecordsetClone.RecordCount
    >
    > --
    > Good Luck
    > BS"D
    >
    >
    > "rg" wrote:
    >
    > > I know this should be easy but I can't find anything that tells me how I can
    > > know the number of records currently displayed in a subform. The number is
    > > known because it's on the navigation bar, but I need my proceedure to know
    > > how many there are. How can I find out from within my prodeedure?
     
  2. Loading...

    Similar Threads Forum Date
    Shabad Numbering System New to Sikhism Dec 1, 2015
    USA A Heart Attack And The Numbers Breaking News Aug 2, 2014
    Pacific Borneo: Sikhs small in number, strong in presence Breaking News Nov 11, 2013
    World Shrinking Numbers and Growing Persecution Threaten Sikhs and Hindus in Afghanistan Breaking News Nov 7, 2013
    SciTech Mammals pick offspring’s sex to maximize number of grandchildren, study shows Breaking News Jul 11, 2013

  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    Me stand for the current form where the code is located in, in that case the
    main form.

    So instead of writing

    Forms![MainFormName]![SubFormName].Form.RecordsetClone.RecordCount

    we can write it
    Me.[SubFormName].Form.RecordsetClone.RecordCount

    --
    Good Luck
    BS"D


    "rg" wrote:

    > Thanks. I've been trying to understand the Me, but it still seems vague.
    > Could you please give me an explanation of what it is exactly?
    >
    > "Ofer Cohen" wrote:
    >
    > > Try
    > >
    > > Me.SubFormName.Form.RecordsetClone.RecordCount
    > >
    > > --
    > > Good Luck
    > > BS"D
    > >
    > >
    > > "rg" wrote:
    > >
    > > > I know this should be easy but I can't find anything that tells me how I can
    > > > know the number of records currently displayed in a subform. The number is
    > > > known because it's on the navigation bar, but I need my proceedure to know
    > > > how many there are. How can I find out from within my prodeedure?
     

Share This Page