Error code 3201??????

[smelly]

Yes it is the first column. I will try 2 and see if that brings up the right text.

I also tried that DLookup and I just get a blank in the text box. Is this the right code for the DLookup function.

=DLookUp("[Company Number]","[Clients]","[Text52] = Form.[Combo6]")

 

[Jack Cowley]

Is the Me.Text52 = Me.Combo6.Column(0) in the After Update event of Combo6? If so, it should work.

=DLookUp("[Company Number]","[Clients]","[Company Number] = " & Me.Combo6.Column(0)

The DLookup should be in the Control Source of Text52.

Jack

 

[smelly]

Yes, I did not have in the after update event and now it works. You are the best. THanks!

 

[Jack Cowley]

Congratulations on another success!

Jack