Unsuccessful with requery from combo to text box

[Spam808]

I a combo with a list of names to choose from and the text suppose display appropriate title associated with the name.

Private Sub cboCom1_AfterUpdate()
Me!Name1.Requery
Me!Name1.Value = DisplayName
End Sub

Everytime I select a name, I receive run-time error 3326.

 

[pbaldy]

Is this what you're trying to do?

http://www.baldyweb.com/Autofill.htm

 

[Spam808]

Is this what you're trying to do?

I did try that solution, and I still get run time 3326 error.

 

[Spam808]

Thank you its working now.

This worked for me Me.Name1 = Me.cboCom1.Column(1), but I have other text boxes associated with cboCom1. I typed Me.Name2 = Me.cboComName1.Column(18), but nothing displayed

 

[pbaldy]

Make sure the column count property of the combo is appropriate. If it isn't, any reference to a higher column than is specified there won't work.

 

[Spam808]

Thank you again

 

[pbaldy]

Happy to help and welcome to the site by the way!