I'm a dork...
I changed my code to this and it appears to work:
Private Sub Customer_AfterUpdate()
Me.Contact_Person = Null
Me.Contact_Person.Requery
Me.Contact_Person = Null
Me.Project_Manager = Null
Me.Project_Manager.Requery
Me.Project_Manager = Null
Me.Project_Superintendent = Null
Me.Project_Superintendent.Requery
Me.Project_Superintendent = Null
End Sub
If one of the pros could confirm though, that would be great!
> I have four Combo Boxes:
> Customers, Contacts, Project Managers, and Superintendents
[quoted text clipped - 19 lines]
> one? I tried adding more After Event Codes using the other field names and
> the computer exploded! :)
Klatuu - 06 Jun 2006 18:30 GMT
You don't the to set the value of the combos to null before the requeries,
only after and only if you want them empty after the requery. Other than
that, you got it.
> I'm a dork...
>
[quoted text clipped - 37 lines]
> > one? I tried adding more After Event Codes using the other field names and
> > the computer exploded! :)
Christian ><> - 06 Jun 2006 18:32 GMT
K. Thanks again!
> You don't the to set the value of the combos to null before the requeries,
> only after and only if you want them empty after the requery. Other than
[quoted text clipped - 41 lines]
> > > one? I tried adding more After Event Codes using the other field names and
> > > the computer exploded! :)