I assume you are the erstwhile Pezzini in a new guise Gail, who has simply lost the previous sign-in details. That way I can allow you to take over the thread (which would otherwise be a hijack). If so, then please don't continue to use the Pezzini account as we don't allow members to use multiple accounts.
ADezii is correct when they indicate that the SubForm Control itself has a
.Requery method that can be called. The bang (!) instead of the dot (.) is not particularly important though, and your syntax was already perfectly valid assuming the control name doesn't clash with any other reserved words or contain any space character within it. Brackets handle all names as expected though, so are always good to know about. Otherwise the only code required is the
.Requery call.
- With Me.[subfrmcontrol]
-
.SourceObject = "FormName"
-
Call .Requery
-
End With
Nothing in ADezii's code will cause a problem of course, but I want you to understand how close you were to getting it right in the first place, and also which parts of the suggested code are the relevant ones. Only the need to include both lines in the one workable solution was missing.