getting a value back from a form

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

From one form, I may need to add a new employee say, so I want to do that by
calling the add employee form. After I save the new employee on that form
and it closes, I want to make the info I just added available in the calling
form.

How would I do that?

TIA,
Eric
 
Use the AfterUpdate event of the form where you added the record to Requery
the other form (or its combo)?

The basic idea (without error handling or checking that the other form is
still open) would be like this:

Private Sub Form_AfterUpdate()
Forms.MyOtherForm!MyCombo.Requery
End Sub
 
Back
Top