I have a form [frmClaimInformation]. I open a popup form from it, to add a new claim. On closing that popup window, I want the original form to be set with the ClaimNumber from the popup, and then requery the underlying query to populate the rest of the form. I am posting the code I have now, which does not work. It is attached on the Close Button of the popup.
The Requery statement is obviously wrong..... what syntax do I need for it?
qry_ClaimInformation is the name of the underlying query.
[Forms]![frmClaimInformation]![ClaimNumber] = Me.ClaimNumber