Update Record with 2nd Sub Form 1

[stlrain95]

I need to update a Master table with a 2nd subform that is filled out later.

But obviously it has to search for the existing data first and then insert the updated data.

Any suggestions??

 

[stlrain95]

I got this to work...but now trying to update the old table with historical data. I built an Update query...but I am getting blank fields returned? Any ideas from this??

BTW, sorry you have been sick.

UPDATE MASTER INNER JOIN QC_IN ON (MASTER.LotNumber = QC_IN.LotNumber) AND (MASTER.PartNumber = QC_IN.PartNumber) AND (MASTER.OrderNumber = QC_IN.OrderNumber) SET MASTER.Start = [QC_IN]![START];

I need to push the start into the Master table from QC_IN

 

[Nowell]

Hi,

It probably doesn't know what [QC_IN]![START] means, where is this data coming from and how are you running the query?