Name not in list help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have "form 1" that creates a project charter. On that form there is a
place for a manager to select from a list different staff members to assume
different roles on the project. If we want to add someone that is not in the
list I have added the following code when not on list occurs. "Form 2" opens
to input the new employee's information, however after the data is entered I
do not know what to do to get the new information entered to appear in the
pull down list or better yet to display the new data in the form. Please
help. the code i have is listed here:

If MsgBox("This person is not in the list." & vbNewLine & "Would you like to
add this name to the list?", vbInformation + vbYesNo, "Not included in the
list.") = vbYes Then
DoCmd.OpenForm "Frml_NewEmployees", , , , acFormAdd, acDialog
Response = acDataErrContinue

Thanks DDBeards
 
DDBeards said:
I have "form 1" that creates a project charter. On that form there is a
place for a manager to select from a list different staff members to assume
different roles on the project. If we want to add someone that is not in the
list I have added the following code when not on list occurs. "Form 2" opens
to input the new employee's information, however after the data is entered I
do not know what to do to get the new information entered to appear in the
pull down list or better yet to display the new data in the form. Please
help. the code i have is listed here:

If MsgBox("This person is not in the list." & vbNewLine & "Would you like to
add this name to the list?", vbInformation + vbYesNo, "Not included in the
list.") = vbYes Then
DoCmd.OpenForm "Frml_NewEmployees", , , , acFormAdd, acDialog
Response = acDataErrContinue
Click to expand...


Response needs to be set to acDataErrAdded to have the list
requeried.
 
Marshall, it still does not update the list unless I leave the record and
come back? thanks
 
Gee, I don't see how that can happen unless there is
something else going on. Are you sure the staff member
entered in the form is typed ***exactly*** the same as the
name that was not in the list?

What is the RecordSource of the two forms and the combo
box's RowSource?
 
Back
Top