Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2003
    Location
    Greenville, South Carolina, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    go to random record on a form (2002)

    I'm creating a vocabulary quizzing database. The main form is based off a sql statement that returns the foreign word, the english word, and the type of speech. After the user makes his choice from a random set of english words, I want the database to go to a random record on the form. I tried setting the CurrentRecord property but no luck there, contrary to the help file's insistence that it's read/write. I'm thinking of adding the autonumber from the foreign table and finding the record that matches the autonumber. Think that would work?

  2. #2
    New Lounger
    Join Date
    Jan 2003
    Location
    Greenville, South Carolina, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: go to random record on a form (2002)

    Stupid me. DoCmd.GoToRecord did the trick. Never mind...I have a bad habit of answering my own questions.

Posting Permissions

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