General discussion


Access 97 - Need to create update query

By AlwaysLearning ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 97 - Need to create update query

by john_wills In reply to Access 97 - Need to creat ...

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.

Related Discussions

Related Forums