CODEWITHSUNDEEP
databasems-access
TheDarkCode
TheDarkCode

Reputation: 411

Save data from MS Access form to another table in the same MS Access database?

I need help for how to save data from MS Access form to another table in the same MS Access database !

I have 2 tables

Table1 -> I called it Data and this table have all the data that generate the form with unique ID
Table2 -> I called it SavedApplications and this table have multiple rows, what i needs that each row to get the data from the form of the first table after the user press the save button

In more simple words. Table 2, first row have unique ID = 1 with some other data in the same row but different columns ! :D and that data came from form that generated from table1

i hope i described my Q very well!!

Upvotes: 1

Views: 3980

Answers (3)

TheDarkCode
TheDarkCode

Reputation: 411

I fixed it by creating a new form from the table that called SavedApplications then i replaced the generated text boxes with new combo boxes & i choosed to get the data from the table that called Data then i mentioned the selected item saved in the the text box field that removed in SavedApplications

Upvotes: 1

Jens
Jens

Reputation: 879

Going by the comment you made on kefash' answer, it sounds to me like you are trying to populate a field in the 1st table with the data in the second?

This is done in the design view of your first table, by giving the applicable field in the lookup tab under field properties a display control of either combo or list box, depending on your needs. Afterwards, change the row source type to a table/query and in the row source, you select the table with your dropdown data.

Did that answer the question or did I completely misunderstand?

Upvotes: 1

Kefash
Kefash

Reputation: 533

What is the relationship between both tables. Is it that you want to have the same data saved in two different tables? If so I would suggest you revisit you database design.

Upvotes: 0

Related Questions