I currently collect various fields of data for a table (we can call it table1) and I have a related field in table2 that I need to update the related field (reviewnum) in table2 when the data is entered into a record at the form for table1 reviewnum.
I can’t add the table to the form as the use of two tables makes the data on the form no longer updatable. I have a complex key of three fields (SONum, SOName and DetCode) that links the two tables together.
I have tried every way possible including a subform, but I can’t get the reviewnum data input in Table1 to update the related record in Table2 in the reviewNum field. Therefore, I was going to program an update query that would update all records when it is run, but I can’t get thequery to use the Table1 SONum, SOName and DetCode fields as criteria in order to update the correct review num field in the records in table2. I get a parameter prompt box when the query runs.
Any help you can give me on the best way to update arelated field in another table when data is input in a form would be greatly appreciated.