Hi All,
I have done some searching with no luck in regards to what I am trying to do. I am still quite a novice when it comes to VBA code. I will be inputting a set of numbers into the field "shop Order #". I want the ANSI field to then populate from another linked table.
The form you see here is attached to a table that I am inputting values into for use in other places. The field that I want to read from is linked Excel file on our network drive; which I know that I have access to. I want to populate this field upon entry of the Shop Order #, but then save it to a field in the input table. Any help that can be provided would be greatly appreciated.