E
Ed Ardzinski
I'm trying to redesign my database, changing several tables where the user
had direct access to the PK of the table to use auto numbers...
On my main data entry form there is a sub form, and this one table was the
subject of todays conversion. Odd behavior when changing records in the
parent form, however. If I move to the end of the recordset (about 10K
records) the field I've changed doesn't appear unless I enter the subform.
If I move from record 1 to record 2 it seems that this field is refreshed
correctly...
I put a Me.Refresh into the Form_Current event of the subform, and it seemed
to do the trick. Until I closed the app with the main form open, and I was
prompted a couple of times for a value from a field in the main form.
It's strange, but when I only look at the records for the particular person
(3 records) the disappearing data doesn't happen, but looking at someone else
who has 8 records in the database it does...
I've tried several other ways to try and refresh this subform, but it
appears that if I try to refresh it in the current event of the parent form
there's a timing issue and the subform isn't open yet...but that doesn't make
sense. I get error 2450 when trying to refer to the actual name of the
subform in the forms collection. Repainting doesn't work, just seems to be
either a requery of the combo box or a refresh of the whole subform...
I'm getting a little frustrated and can't seem to think beyond what I've
tried. Any suggestions would be appreciated. Thanks!
had direct access to the PK of the table to use auto numbers...
On my main data entry form there is a sub form, and this one table was the
subject of todays conversion. Odd behavior when changing records in the
parent form, however. If I move to the end of the recordset (about 10K
records) the field I've changed doesn't appear unless I enter the subform.
If I move from record 1 to record 2 it seems that this field is refreshed
correctly...
I put a Me.Refresh into the Form_Current event of the subform, and it seemed
to do the trick. Until I closed the app with the main form open, and I was
prompted a couple of times for a value from a field in the main form.
It's strange, but when I only look at the records for the particular person
(3 records) the disappearing data doesn't happen, but looking at someone else
who has 8 records in the database it does...
I've tried several other ways to try and refresh this subform, but it
appears that if I try to refresh it in the current event of the parent form
there's a timing issue and the subform isn't open yet...but that doesn't make
sense. I get error 2450 when trying to refer to the actual name of the
subform in the forms collection. Repainting doesn't work, just seems to be
either a requery of the combo box or a refresh of the whole subform...
I'm getting a little frustrated and can't seem to think beyond what I've
tried. Any suggestions would be appreciated. Thanks!