I have a table with account numbers and their associated descriptions.

How do I get the description field to auto populate based on the account number entered?

On my first read of your Q I was going to suggest you use the Dlookup() function, but since both fields are in the same table, I assume you mean to ask how to get form record pointed to the right acct number/description, based on the Acct# entered by the user.

If that is true, and you are using Acc2K, the combobox wizard will handle the job (this might work in earlier versions as well but not sure).

HTH,

TGH

PS -- in the future I suggest you let us all know in your Q what version of Access you are using http://www.access-programmers.co.uk/ubb/smile.gif