getting a value back from a form

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
 
A

Allen Browne

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
 
Top