Here's the situation. A form, frmSetUp, with a subform control called
subExplain with a source object form frmSetUpSubDefineSides. The source
object is a bound form, displaying a few records, no edit, adds,
filters, etc, are permitted on the subform.
An add or edit button on the subform is clicked opening an unbound form,
frmSetUpSideAdd, (populated with values from the above subform if this
is an edit of an existing record) for data entry. The command in both
cases is DoCmd.OpenForm "frmSetUpSideAdd", acNormal, , , , acDialog
Data is added/changed on this dialog mode form and then an OK button
creates an insert or update statement, and I run the execute method in
ADODB. Works just fine.
However, the subform on frmSetUp does not refresh until I physically
click on the subform or prress F9: I've tried the following and several
setfocus type fiddling around:
docmd.close 'for the acDialog add/edit form, frmSetUpSideAdd
Forms!frmSetup.subExplain.Requery
Forms!frmSetup.subExplain.SetFocus
Forms!frmSetup.subExplain.Form.Refresh
I've also tried tossing in SendKeys "{F9}" and a Recalc and neither
work. I've also tried respecifying the source object, ie:
Forms!frmsetup.subExplain.SourceObject = "frmSetUpSubDefineSides"
But that won't work either.
Please help. A2K3 on Win XP SP1
--
Tim -
http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto