Hi again!
I know I'm new to this message board and I hope I'm not aggrevating everyone with posting so much. It's just such a great source to find out things I haven't been able to find in my Access Bible or the Access help.
Anywho...
I have about 40 different food items for sale in this program. They are divided into 4 tables. On my main screen I will have each item listed with a button next to it that, when pressed, will increase that item's quantity by 1. I know how to do this using a macro assigned to each button, but I was wondering if there is a faster, more efficient way of doing this. I will have to create 40 macros and 40 buttons. I'm wondering if this will slow the program down too much.
Is there a better way?
Thanks,
Stacey
I know I'm new to this message board and I hope I'm not aggrevating everyone with posting so much. It's just such a great source to find out things I haven't been able to find in my Access Bible or the Access help.
Anywho...
I have about 40 different food items for sale in this program. They are divided into 4 tables. On my main screen I will have each item listed with a button next to it that, when pressed, will increase that item's quantity by 1. I know how to do this using a macro assigned to each button, but I was wondering if there is a faster, more efficient way of doing this. I will have to create 40 macros and 40 buttons. I'm wondering if this will slow the program down too much.
Is there a better way?
Thanks,
Stacey