Adam - try Me.Requery instead of Me.Refresh.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.microsoft.com/en-us/PublicProfile/35852?fullName=Bill%20%20Mosca
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <runuphillracing@yahoo.com> wrote :
Yes. See original message.
---In MS_Access_Professionals@yahoogroups.com, <sigurd@...> wrote :
---In MS_Access_Professionals@yahoogroups.com, <sigurd@...> wrote :
Have you tried adding
Me.Refresh
Sigurd Andersen
Me.Refresh
Sigurd Andersen
On 12/14/2015 3:32 PM, runuphillracing@... [MS_Access_Professionals] wrote:
I have a form based on a non-udateable query. To change data in a field, I click on the field, it makes visible an unbound combo box, assigns the underlying value to that combo box (Me.cmbSID = Me.SID), and shifts focus to that box. AfterUpdate changes the value in the underlying table:
stSQL = "UPDATE tblParentList SET tblParentList.SID = '" & Me.cmbSID & _
"' WHERE tblParentList.ParentID = " & Me.ParentID
Db.Execute stSQL, dbFailOnError
Me.Refresh
The update happens in the underlying table. However, that change isn't reflected on the form.
What am I missing?
Adam
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar