Automatically run update query when adding new line

[ibracadabra]

Hi everyone,

I have a question. So I am trying to set up access to automatically run the update query when adding new record. In this sample, I wrote a query to update all Course_ID = 10 if they have Deparment_ID= 4. My question is how to let Access update automatically if I add a new row. For example, for the fifth row, if I input 4 for my deparment_id, Access itself will generate the Course_ID = 10 without me running the query. Thank you!!



Attached is the sample file for this case.

[Micron]

You should not be routinely entering data into a table directly. I say routinely because one might add a few records this way for testing, but that's about it. You will need a form where its record source is the table or a query based on the table. The simplest method then would be to use the AfterUpdate event for the field you're entering 4 into so that it makes the other field = 10. You could do the reverse as well if desired. You can get help with that approach once you have the form built - unless someone gives you an idea you like better.