in the last field (text) of a form (based on Table1), I have created a private sub, which should copy these data simultaneously to a second table (Table2)
my problem now is, that this doesn't work before I have entered the next line in the form,
telling me that "the data cannot be inserted because they have to be in relation to the other table"
(the procedure works well, as soon, as I go to the next line. and then back to the field with the procedure... but its quite uncomfortable for each line to go back and forth , to make the copy-Process work...I have thousands of lines ... book-keeping)
is there any comand I could insert to the procedure to save the data of the line I'm in first in Table1 and then start the redordset for Table 2???
when I use "requery" the curser jumps to the beginning - that's no good...
thus I'm looking for a command that either leaves the curser on the field I am or jumps to the next line...