Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009

    Unanswered: Access Lucky Draw Form


    Here is my situation..

    We are having a lucky draw on Saturday and we have sold 200 tickets that have individual numbers. We have 200 prizes on offer.

    I have created a form which allows me to enter the ticket number but I want the name to appear for the individual who has the ticket. We are going to use a projector so whenever the number is drawn we want to be able to enter the number on the screen and then the name pop up for the winner.

    I have two tables:-

    prize (includes prize number, prize description and ticket number)
    ticket(ticket number, ticket holder, ticket address)

    Any help would be useful?

    Does anyone know of anything out there that is like this?


  2. #2
    Join Date
    May 2005
    welcome to the forums

    I would create a read-only form whose control source is a JOIN query. Then create some kind of a way to enter in the ticket number and jump to that record (there are many ways to do it depending on personal style).
    Me.Geek = True

Posting Permissions

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