I have a form based on two temp tables. In the header, once I enter our order number, I bring up many lookup fields in the header table. This works fine. I also want to Insert rows into the second table. This happens but the information will not show until I enter the second table.
I decided to use the RECAL TABLES in the On exit EEP below INSERT INTO tBOLRows (Control#, Model#, Sortone, Outshipinv, Quantity) + SELECT Control#, Model#, Sortone, Outshipinv, Quantity FROM OrderRows + WHERE Control# = .vControl RECALC TABLES RETURN This does bring up the rows but two things happen. Three fields go blank in the Header then when I leave the next field the rows disappear in the second table. I read the Help and it states, 'The TABLES option recalculates lower tables only, not the current table.' It seems to be recalculating those three fields Jim
