Hello All,
I am not incredibly skilled in visual basic. I have manipulated script to suit my needs but have never written it myself. I am in need of help/direction.
I have a database which was designed by someone else. I am looking to update a table in this database using a form that is connected to and partially updated by a query that is comprised of several different tables. The person originally working on this database built the original form for completly manual data entry with it linked to the table which requires update/new records.. My goal is to eliminate much of the manual work by auto-populating the form/query with different search criteria, but this requires that I do not use the table that needs to be updated.
As an example, I want to update tbl_a. I am using qrySearch to populate much of my form. The form has several tables linked to it as drop down boxes for user selection in addition to the query populated information. The form has fields data1, data2 and data3. The table has field Dataaaa1, dataaaa2 and dataaaa3. data1 = dataaaa1 and so on. There is a command button on the form to "Save" the data to tbl_a.
How would I go about updating this table with an event after click on the save button from the form?