If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Forms/Fill-in
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? |
Thread Tools | |
Display Modes | |
|
|