[MS_AccessPros] Re: Form not updating after underlying data changed

 

Yes. See original message.

---In MS_Access_Professionals@yahoogroups.com, <sigurd@...> wrote :

Have you tried adding
   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: runuphillracing@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___