Access, lookup for data in another table if matches update the current cell

Question

In my access database i have two tables:

Master_Table
Material Return Data
In my material return data table , i need to update "complaint recived date" automatically based on the "complaint number"(both the column data is available in master table) & rest of the column data will entered manually. To update "complaint recived date" automatically based on the "complaint number" , I have entered below sql query in the row source of the column , while running the query it is showing correct data but in the table it is not updating , kindly help me.

SELECT master_table.[Complaint Received On] FROM master_table WHERE (((master_table.[Complaint Number])=[Complaint_No])); 

SQL query entered as row source:
SbSQi.png

Query result:
eqqJJ.png
Dssc8.png

table image:
fKnZg.png

Answer 1

Hello,

Welcome to Q&A!

The tag sql-server-general indicates that this is a zone for discussing SQL Server technical issues.
According to your description(access database ,Row Source) and the images provided, this question is more related to Microsoft Access, please ask this in relevant zone(office-access).