Have you tried adding
Me.Refresh
Sigurd Andersen
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: Sigurd Andersen <sigurd@solbakkn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar