SubForm record redisplay

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

B Moody - 16 Jan 2008 17:41 GMT

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.

Reply to this Message

Douglas J. Steele - 16 Jan 2008 17:51 GMT

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)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> 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.

Reply to this Message