Guest_imported
New member
- Jan 1, 1970
- 0
a newbie at VB/VBA syntax, so I'm wondering how I would do this....
I have a DB that tracks orders. I have a form set up where the user enters order information. There is a field on that form that display's the vendor company's id number (this links back to their name). There is another field that is to be used for a purchase order number. In my form, you can only order one product at a time, so what I want to do is say something like " when the save order button is pressed - if the vendor number does not change (ie..the user doesn't pick a new vendor), then the purchase order number value should not change (ie...another product will be put on the same po for the same vendor)but if the vendor number does change, the value in the purchase order field should advance +1 (ie..the user has picked a new vendor so make a new purchase order)"
make sense??
Thanks!!
I have a DB that tracks orders. I have a form set up where the user enters order information. There is a field on that form that display's the vendor company's id number (this links back to their name). There is another field that is to be used for a purchase order number. In my form, you can only order one product at a time, so what I want to do is say something like " when the save order button is pressed - if the vendor number does not change (ie..the user doesn't pick a new vendor), then the purchase order number value should not change (ie...another product will be put on the same po for the same vendor)but if the vendor number does change, the value in the purchase order field should advance +1 (ie..the user has picked a new vendor so make a new purchase order)"
make sense??
Thanks!!
