Welcome to SPN

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

Sign Up Now!

Opening a form showing only some data

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

  1. MartinR

    MartinR
    Expand Collapse
    Guest

    I wish to open a form in database view showing only the data that has
    nothing in the date returned field.

    Currently this is the code i have but it is not working.

    Dim stDocName As String
    Dim stLinkCriteria As String

    stLinkCriteria = IsNull([Date Returned])
    stDocName = "Returnsform"
    DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria


    The problem is in the "stLinkCriteria...." line of code. It says the
    Database cannot find the field "|" reffered to in your expression. What
    code should i use or should i use a filter or a query to do this?

    Any Ideas..

    Martin
     
  2. Loading...


  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Add this line to your code, above the OpenForm line:
    Debug.Print stLinkCriteria
    You will see that your criteria string does not contain a valid expression.
    It will contains something like -1 (the value of True, if the expression is
    True) or 0.

    Now replace your 3rd line with:
    stLinkCriteria = "[Date Returned] Is Null"
    and see how you go.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "MartinR" <martin.ryan@esbi.ie> wrote in message
    news:1153814504.099121.279840@b28g2000cwb.googlegroups.com...
    >I wish to open a form in database view showing only the data that has
    > nothing in the date returned field.
    >
    > Currently this is the code i have but it is not working.
    >
    > Dim stDocName As String
    > Dim stLinkCriteria As String
    >
    > stLinkCriteria = IsNull([Date Returned])
    > stDocName = "Returnsform"
    > DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria
    >
    >
    > The problem is in the "stLinkCriteria...." line of code. It says the
    > Database cannot find the field "|" reffered to in your expression. What
    > code should i use or should i use a filter or a query to do this?
     
  4. MartinR

    MartinR
    Expand Collapse
    Guest

    Cheers Allen, That worked perfect. Yet again you come to my rescue.
    Thanks
     

Share This Page