Update linked data on form

[esskaykay]

Hello,

I’m trying to update one table based on data in a second.

As a test I have setup a simple Data Entry form with two text boxes (txtGIS_Ownername & txtParID). Its record source is a select query linking GIS and tblPermits tables by the field ParID. Ultimately I want tblPermits updated to data in GIS but as test I simply want to see the data in GIS.

When I key-in the ParID, I expected to see the OwnerName but it’s not the case. However, if I move to the next record and return (or close the form and reopen), the OwnerName is there. I’m assuming there is some code required on my ParID’s “After Update” event but not sure what. I have tried to no avail:

Me.Refresh
Me.Recalc
Me.Repaint

Any suggestions would be appreciated.

Thanks,
SKK

 

[boblarson]

You tried everything but the one you need

Me.Requery

 

[esskaykay]

Ahh, I think we're on to somehting. However, this form was opened in acFormAdd mode. When I run the Me.Requery it closes the form (which I understand it would). Do you think there is some other way I could update the form without closing it?

SKK