Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    5

    Unanswered: Access Form Help

    hi i been trying to make a form, which allows me to add a player record in player table and contracts at the same time whilst assigning a team to the player on the same form but it keeps giving me errors, its like my player_id in players table is not linked to player_id in contracts table( i have linked them on relationship window and by lookup wizard in design view)
    Attached Thumbnails Attached Thumbnails Untitled.jpg  

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    What are the error messages?
    John M Reynolds

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    We really do need to know what error messages are appearing. The code that the poster perceives as causing the problem is often not the problem.

    What are the Datatypes of the various Player_IDs? The Datatypes must match, unless one is an Autonumber, in which case the others must be defined as Numbers/Integers.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Tags for this Thread

Posting Permissions

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