Software

Ask something
Discussion Locked

Access 97 - Need to create update query

0 helpful
1 reply

by alwayslearning

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

1 reply

by john_wills

Parameter prompt boxes can be very annoying, but they are usually explainable. The probability is that you have a mis-spelling in your WHERE clause. Look carefully at what the prompt box is asking for and ask yourself why it doesn't already know.

This discussion is closed to new replies.