This is regarding a sub-form that pretty much operates independently of the main form (other than to tie the PKs together).
My problem is I can't figure out what order to run the event procedures to make the results of an update-query show in the sub form.
***
Beginning - Dropdown combobox with project name
Middle - ???
End - on entering a Comment field I use "me.form.refresh" to refresh the data in the subform.
***
Here's what I have so far:
It updates all previously entered records just fine, but it won't update the current record. From my rummaging around I think this has to do with when Access saves data, but I can't figure out where my order of operations goes wrong.
Any help is appricated.
Thank you!
***************************************
Have a problem with my spelling or grammar? Please refer all complaints to my English teacher:
Ralphy "Me fail English? That's unpossible." Wiggum
My problem is I can't figure out what order to run the event procedures to make the results of an update-query show in the sub form.
***
Beginning - Dropdown combobox with project name
Middle - ???
End - on entering a Comment field I use "me.form.refresh" to refresh the data in the subform.
***
Here's what I have so far:
Code:
Private Sub Project_Name_Change()
Dim stDocName As String
stDocName = "UpdateShareData"
Me![Contact Date].Value = Date
DoCmd.SetWarnings False
DoCmd.OpenQuery stDocName, acNormal, acEdit
DoCmd.SetWarnings True
DoCmd.Save
Me!Comments.SetFocus
DoCmd.Save
End Sub
Private Sub Comments_Enter()
Me.Form.Refresh
End Sub
It updates all previously entered records just fine, but it won't update the current record. From my rummaging around I think this has to do with when Access saves data, but I can't figure out where my order of operations goes wrong.
Any help is appricated.
Thank you!
***************************************
Have a problem with my spelling or grammar? Please refer all complaints to my English teacher:
Ralphy "Me fail English? That's unpossible." Wiggum