I have an access2002 database which has several tables linked to another read only sql database. I am trying to develop a form in my database where a person will select a person from a drop down and then all of their information will populate to the form and also be able to add to a comments box I will create and when I hit the next button it will store that data to the table I developed. I currently have a table which I have all of the possible fields I will need to store. I also have a query which populates all of the information from the various linked tables. For example, the query has the personsid, firstname, lastname, address, etc. I was able to create a form and make a combo box which gets the data from the query and then stores the id number in the table when I click next, however, I need to also get it to store the other information with it. Where am I going wrong.
Thanks, Dale
