field autofill base on secondary field text?

B

Brook

Good Day,

I have a frmcheckingacct that is based on qrychecking, with the following
relevant fields: Debit_CreditDescription, Catagory. Currently the field
Catagory is a lookup for the user to select the type of charge the
description is, I.E. Office Supplies, Shipping, etc. I was wondering if there
was a way to perform a text search on the field Debit_Credit Description and
assign a catagory that way?

any ideas / suggestions?

Thanks,

Brook
 
J

John Smith

Better to add a category column to your Debit_CreditDescription lookup table.
You can then change the categories as and when required, and you can be sure
that it will be!

HTH
John
 
Top