Results 1 to 3 of 3

Thread: Command Buttons

  1. #1
    Join Date
    Feb 2006
    Posts
    23

    Unanswered: Command Buttons

    Hello there,

    I am creating a learning tool using Access for my students. Currently I have a topic form, this has a number 1 to many relationships going from it to other tables, such as 'questions', 'exercises', 'theory' etc.

    I know how to create a command buttong to access these other forms, however it accesses all the information in these forms. To explain better, if I have the Topic 'addition' and a command button linking to the Question form, i only want it to show the 'addition' questions, not all the other questions in the database. Any advice would be much appreciated,

    Ross

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Depending on how you built your forms try applying a filter (or criteria) when you invoke the form ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Feb 2006
    Posts
    23
    Quote Originally Posted by M Owen
    Depending on how you built your forms try applying a filter (or criteria) when you invoke the form ...

    Ahhhhh i think ive cracked it, i matched a couple of fields in the command button wizards and it seems to have done the trick, thanks for the tip :-)

Posting Permissions

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