Unanswered: Issue with requery combo
I created a not_in_list event procedure using vba that inserts the data into table then opens form with that record to allow additional data to be added for that record. My problem when I close the form used for edit I have placed vba on close event of the dit form to requery the combo of the original open form where the not_in_list event originated. The issue is it does not refresh allowing the use of the newly created record. I have included vba code for both as review.
not_in_list event vba
Form Close event vba
Private Sub cbo_ID_Part_NotInList(NewData As String, Response As Integer)
' Prompt user to verify data input is correct.
Answer = MsgBox("Do you want to insert " & NewData & " into the Part Number list?", vbYesNo, "Part Number not found!")
' Answer yes = insert data into data table
If Answer = vbYes Then
Part = NewData
SQLStmt = "Insert into tbl_Part(Part) values ('" & Part & "')"
Response = acDataErrAdded
' After data insert open form to add description not on this form
DoCmd.GoToRecord , , acLast
Forms!frm_Part.[Part] = Part
Private Sub Form_Close()
"Discovery consist in seeing what everyone sees and thinking what nobody has thought"