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

    Unanswered: creating a form from a query ((very basic!))

    Hi guys,

    im very very new to access and ive been trying to figure out how to fix an error i have in creating a form. i have read the FAQ guide and still cant fix this, ive been trying for hours!

    i have created a query from two seperate tables, and then created my form off that.

    ive uploaded the database (its very small) so you guys can see what im explaining! it can be found at the link below

    MEGAUPLOAD - The leading online storage and file delivery service

    i basically want to search for the acession number of a CD have it bring up the artists and title, input the issue date and the due date.

    i also want the user to enter the borrower ID number have it save in CD copy table, and veiw the borrowers details at the same time.

    i get several errors when attempting this, the find function for example wont search the acession number giving the error "the command or action "find" isnt available now"

    and when i try to enter the borrower ID number i get a message in the bottom bar stating "cannot add record join key of table cd copy not in record set"

    i realise i must of explained this really bad, if there is any information required i will do my best to explain it. i would appriciate any help what so ever in how i can fix my problems :-)

    thanks in advance

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    1) Find is a method for ADOBD recordsets, try with FindFirst <criteria>.

    2) How is your query built ?

    Have a nice day!

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    Make sure you include the primary and foreign keys in your query!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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