I am using Access 97. I have a subform in which I have the following two fields:

account number (100)
account number description (Office Supplies)

I want the description field to autofill when the user enters the account number.

I also have another table not the same one linked to the subform that has just two fields, account numbers and related descriptions.

I tried the help in Access for autofill. But it is not working.