One of the databases is read only. The one that currently houses several different tables with peoples information is read only.
I have linked to those tables in a database that I can write to. The database I can write to has the linked tables plus one additional non linked table that I created. The nonlinked table I created currently has nothing in it except several fields such as Autonum, ID, FirstName,LastName, Address, City, State, Zip, Comments, etc. I can manually enter data into this table. The other thing I created in the database is a query which pulls the read only information from several different tables so it is presented in a nice format. If I run the query it will display everyones id, firstname, lastname, city, state, zip, etc. Now what I need to happen is to create a form that allows me to select a person and then place all of the relevant information in the table I created. Thanks, Dale --- Lonnie Johnson <[EMAIL PROTECTED]> wrote: > 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] > > "In the 60's people took acid to make the world weird. Now the world is weird and people take Prozac to make it normal." __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
