Hi, I have a subform where I have some bound fields tied to a temporary table . I have a save button where I execute an append query to append the data to the main table I need it in. (I am doing this to control the data entry through having to click a “save” button.) When data is entered into the fields, it does not automatically update the temp table right away but if I click on a different record, then the data finally shows up in the table.
Why doesn’t the data show up in the temp table without having to trigger it by clicking on a diff record? Is this normal ?? Is there a command I can add to my save button to force data to the temp table before doing the execute append query?
thanks!
Why doesn’t the data show up in the temp table without having to trigger it by clicking on a diff record? Is this normal ?? Is there a command I can add to my save button to force data to the temp table before doing the execute append query?
thanks!