SubForm record redisplay

[B Moody]

AC 2003. I have a form with a subform in datasheet view. I do not allow Add
records in the subform, but provide a button on the main form that opens
another form which adds one or more records to the table in the subform.
How can I get the subform to redisplay showing the newly added records? I
thought subform.requery would work but it doesn't.

 

[Douglas J. Steele]

Are the name of the subform control and the name of the form being used as a
subform (the SourceObject property of the subform control) the same? If
they're different, it's the control name you need to use, not the form name.

If that still doesn't work, try:

Me!NameOfSubformControl.Form.Requery

(assuming you're calling this from the parent form)