Hi,
I have unbelievable problems just to save a record!
I make an input to a record in a subform, which has a
temporary table as its recordsource.
When I am done, and want to save the record, I want to bring
the data from the temporary table over to the regular table.
But the data isn't in the temporary table yet, it is still
on the form.
So I do the obvious 'DoCmd.Save'. That has no effect.
The temporary table is empty.
I do 'Parent.SetFocus' to leave the subform and possibly
force a saving. This has no effect.
The temporary table is empty.
I try to use the Recordsetclone of the subform to get the
data from it, but this is for some reason empty.
I do 'Docmd.Close acForm, Me.Name', referring to the
subform. Plus 'DoEvents'. But the subform does not close at
this moment.
And still the data does not appear in the temporary table
which is/was the recordsource for the subform.
Not until I have completely left the Saving procedure does
the subform close and the data appears in the temporary
table.
But the first idea with the Saving procedure was just to
bring the data over from the temporary table.
Of course I can now open a new procedure and catch the data
from the now filled temporary table...
But it cannot be this stupid, I must have missed something.
Can you give me some hints?
Larry