Search results

Problems are back... The form again gives the #Name? error for some fields - it is corrected if I reselect the Record Source table from the Data Tab of the Form Properties. After I redirect the data source it works fine. It continues to work on closing and reopening, but once I compact and...

Don't know why, but things resolved... ...God only knows, but the same form works perfectly again!? I suppose that's a good thing, but will it go bust again?

:mad: What is the problem with Access and Corruption? It is SO bad. In one evening my command button macros open the wrong forms, my main form does not recognise basic field data (#Name?), and some command buttons give me a "Return without GoSub" error - Compact and Repair does not fix this...