no built in functions as such but if your category control is a combobox you could set the rowsource to something like
Code:
SELECT *
FROM tblCategories
WHERE [TranDesc] Like '*' & CategoryDesc & '*'
[TranDesc] would be the name of your description control on the form and it will list all the categories where there is a match so the user has a limited choice. You would also need some code to set the value if the user does not specify one
Problem would be if there are no matches for the user to choose from or the categories selecte are wrong, so you would need some code in the notinlist event so user can add a new one or to expand the list. All depends on what your descriptions and categories are