Moving between two inter dependent forms 2

[LD1010]

I have a form, frmNewClaims used to record new insurance repair projects to tblClaimLog. Among the many fields is ClaimAdjusterID. The user picks an adjuster from a combo box cboClaimAdjuster. (All adjuster contact information is stored in a table called tblAdjusters.)
Sometimes the adjuster is new and is not yet in the tblAdjusters and thus doesn’t show up in the cboClaimAdjuster. This means the user must first enter the new contact information by opening the frmNewAdjusters and then coming back to frmNewClaims in order to populate the ClaimAdjusterID field with the correct ID.

Is it possible (when the adjuster contact is new)to open the frmNewAdjusters, add the new contact, close that form and then come back to the frmNewClaims, requery the cboClaimAdjuster and set the focus back to that combo box?

Thanks in advance for your help.

 

[PHV]

Have a look at the NotInList event of the ComboBox object.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[LarrySteele]

If you need more information on the NotInList event, you can take a look at faq702-4283: Combobox - Add New Item to List

 

[LD1010]

Thanks PHV and LarrySteele that's what I needed.