Dlookup

[cbrsix]

I have a form that I want to use the dlookup function. I want this form to look up the AccountNumber that I type in and I want it to grab the Company Name and Account Type from the client table. The Company Name information, from the client table, is a drop down menu that draws from a query I had set up. The Account Type information, from the client table, is just a drop down list created in that table (no query).

Here is what I thought would work, but it's not. Any ideas? Does the query mess it up?

Private Sub AccountNumber_AfterUpdate()
Company = DLookup("Company Name", "Account List", "Account Number=" & AccountNumber)


AccountType = DLookup("Account Type", "Account List", "Account Number=" & AccountNumber)

End Sub

[boblarson]

Why not just use a combo box with AutoExpand on? Then you can simply start to type and it will "find" the record. The Company and Account Type can just be fields in the Combo's Row Source which then can be referenced from the controls that display it:

=[ComboNameHere].[Column](1) ' for the second column as it is zero-based
=[ComboNameHere].[Column](2) ' for the third column

And you should not be storing this information in another table so just displaying it like that would be the best.

[cbrsix]

Thanks you.