Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2015
    Posts
    22

    Unanswered: Update a new table through a form with data from another table

    Hi All,

    A have a table, let's call it ONE and I would like to import data though a form. I want also the ttwo colums of this table to be filled with data from another table, let's call it TWO, where the DATE and the CODE meet the criteria.
    It may sound very easy to some of you but I am not very familiar with databases...

    Every help is appreciated!

    ONE.DATE - ONE.CODE - TWO.VALUE1 - TWO.VALUE2 - ONE.VALUE3

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    602
    Provided Answers: 31
    Use an update query. Bring in both table into the query, join on the common field, use criteria from the form.
    Docmd.openquery "quUpdateForm"

    QuUpdateForm=
    Update one,two set [field]=forms!myForm!cboBox where one.field1=two.field2

  3. #3
    Join Date
    Oct 2015
    Posts
    22
    Thank you very much Ramman for your answer but I think I am more confused now! :-)

    Anyway I will give it a try and I will let you know. Do you think there is any other way to achieve that?

    To discribe the project, I want to make a db for tracking my bets.

    So I have a table with the offered games sorted by date and code and I want to bulid a new table where I will insert the date and the code and the two teams will be entered to the new table automaticaly.

    Then I will fill manually my pick.

    I wonder if my approach is right.


    Click image for larger version. 

Name:	Untitled-1.jpg 
Views:	3 
Size:	52.2 KB 
ID:	17223

Posting Permissions

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