I have a form with a combox to choose sales reps from I would like to update a email field form a table that has their name and email and Phone ext. in it.
here is what I have: Private Sub AEName_AfterUpdate() 'salesrepemail.Value = Table!RepsName!salesrepemail salesrepemaila = Null salesrepemaila.Requery salesrepemaila = Table.RepsName.salesrepemail.Column(5) End Sub I have tried a few things but keep getting a Run time error '424' Object required any help would be great, thanks
