I have done this before, don't know why I am having such trouble this time!!!
I have a table tbl_items. In this table are 3 fields-autonumber, item number, and item description.
In my form, I am trying to make this "autofill". What I need to do is in box 1 choose the item number and in box 2 have the description for the item number chosen in box 1 to fill in automatically. Example:
auto number item number descritpion
1 1234 cutter
2 1235 stapler
3 1236 speaker
Item number 1234 Item description <<this is where I want the description to go from the item number 1234 chose in the previous field>>>
How do I do this? As I said I have done it before (a couple of years ago) and for the life of me, cannot remember how to do it now!!! This is so frustrating!!! Please help!!