Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2011
    Posts
    11

    Unanswered: If amount = 0 then no record

    How can I achieve the following thing.

    If the amount is 0, the record must not be shown in the form.
    If the amount is 1 or more, the record must be shown in the form.

    (see attachment)

    The text in the attachment is in Dutch, but it concerns 'aantal'.

    Thanks in advance.
    Attached Thumbnails Attached Thumbnails HW.bmp  

  2. #2
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Depends on how you populate form. Do you have code to share? If the results are from a db query then filter out records in the sproc.

  3. #3
    Join Date
    Jan 2011
    Posts
    11
    Sorry, this is a dubble post

    I already have the solution, but thanks anyway

    http://www.dbforums.com/microsoft-ac...no-record.html

    Quote Originally Posted by corncrowe View Post
    Depends on how you populate form. Do you have code to share? If the results are from a db query then filter out records in the sproc.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •