Can anyone tell me if this is a feature or a bug? Please see my attached database:
Views: 6 Size: 436.0 KB">test1.accdb. It is compatible with Access 2007 to 2016. The following phenomenon occurs in Access 2007-2016 as well.
I have a "Query1" and "Form1" that both have the same data source, which is "Table1" linked to a "Table2" in a left-join 1-to-1 relationship. Now perform the following steps:
1. Open Query1, and enter a new record by filling in Field1, Field2, and Field3. Leave Field4 and Field5 blank for now. Save the record.
2. With Query1 still open, open Form1. Go to the record you just created, and change Field3's value and also enter values for Field4 and Field5. Save the record.
3. Now look at Query1. Field3 has the updated value you just entered in Form1. But why aren't Field4 and Field5 showing updated values?? They are still blank. You have to either press F5 to refresh the query or close and reopen the query to see the updated values.