In the first sentence you said the database was read only. Is that the problem?
May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us ----- Original Message ---- From: Dale <[EMAIL PROTECTED]> To: [email protected] Sent: Friday, December 29, 2006 8:25:28 AM Subject: [ms_access] Form creation 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 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed]
