J
Jaguar
Using Access2000. My form is based on a query that
combines 2 tables (Availables and Master UPC file). I'm
in the grocery business so I use UPC numbers broken into
3 parts, the MFR designated front 5 numbers, the Item
number (the next 5 of a UPC), and a case code. What I'm
looking to do is if I'm quoting several items to a
customer normally much of the info will be the same. For
example, if I'm quoting Campbells Soup, they all start
with 51000 (front 5 numbers)then all the items which are
the next 5 numbers.....generally they'll all have the
same List price, same cost, same ship date, etc so i'm
looking for the form to auto fill certain fields that
were entered on my last item, ie front 5 numbers, cost,
FOB, ship date, and notes. For the life of me I can't
figure this one out. Any suggestions?
combines 2 tables (Availables and Master UPC file). I'm
in the grocery business so I use UPC numbers broken into
3 parts, the MFR designated front 5 numbers, the Item
number (the next 5 of a UPC), and a case code. What I'm
looking to do is if I'm quoting several items to a
customer normally much of the info will be the same. For
example, if I'm quoting Campbells Soup, they all start
with 51000 (front 5 numbers)then all the items which are
the next 5 numbers.....generally they'll all have the
same List price, same cost, same ship date, etc so i'm
looking for the form to auto fill certain fields that
were entered on my last item, ie front 5 numbers, cost,
FOB, ship date, and notes. For the life of me I can't
figure this one out. Any suggestions?