Bound Text Box Not Requerying

[altemir]

I have a button control on a subform that opens another input form modally. The problem is that a text box control on the original subform won't requery after the second modal input form is closed. Why???

Here's my code .... any thoughts??

DoCmd.OpenForm "frmAttachments", , , "ComplaintLineID = " & CStr(Me.ComplaintLineID), , acDialog

Me!txtNumAttachments.Requery ' <--- doesn't work; Does nothing to refresh the displayed data

[orange]

Do you get an error message?
Is there any control on the modal form that you need in the subform? Just thinking if there was a value needed and the modal form was closed, that would be an issue?????

[altemir]

No, I don't get an error message. The text box just doesn't display the updated value.

Regarding your second question, no value needs to be passed from the modal form ("frmAttachments") to the original subform. The modal input form updates a value in the table that underlies the subform using a DoCmd.RunSQL statement. I can see that the table value is correctly being updated because the text box on the subform that is bound to it does have the updated value. IThe subform will correctly display the updated value only if I close the subform and then reopen it. I ran the .Requery method so the user wouldn't have to close the subform to see the correct value.

[Missinglinq]

The first question for this kind of thing would be is txtNumAttachments spelled correctly? It's not txtNumAttachment, with the ending 's,' for example?

Another possibility could be that the Control has become corrupted. When we think of corruption, we think of Forms or even entire Databases, but Controls can and do become corrupted, as well. The test for a corrupted Control is the same as the solution, you delete it and the recreate it.

Just out of curiosity, is doing a Requery of the Subform, itself, out of the question?

Linq ;0)>