Not really answering my questions.
Re frm_Runs_Add: "there is data from two tables on this form - there is a run table and a lot table" - should I make assumption that the Lot info other than LotID is NOT being duplicated into Runs table?
I am not understanding why the code fails. Again, if you want to provide db I will try to debug.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.