Hi all,
Please see the attached database. What I'm asking for is probably simple for most of you, but is tricky for a newbie like me.
If you take a look at formWarehouseData, you'll (hopefully!) get an idea of what I want/am trying to do:
I'd like to be able to use the three combo boxes to select a ticket, location and article from tableWarehouseData. This should display the quantity for that ticket/location/article under "The current quantity is:." Then, I would be able to enter a new quantity for that ticket/location/article under "The quantity will be changed to:", click the OK button on the right and have that update tableWarehouseData for the selected ticket/location/article immediately.
For example, if I selected ticket 1111A1, location 90003 and article 9326302909, 6 would appear as the current quantity. If I entered 77 and clicked OK, then 77 should become the new value for ticket 1111A1, location 90003 and article 9326302909.
Any help is appreciated!
Thank you!
Tony
Please see the attached database. What I'm asking for is probably simple for most of you, but is tricky for a newbie like me.
If you take a look at formWarehouseData, you'll (hopefully!) get an idea of what I want/am trying to do:
I'd like to be able to use the three combo boxes to select a ticket, location and article from tableWarehouseData. This should display the quantity for that ticket/location/article under "The current quantity is:." Then, I would be able to enter a new quantity for that ticket/location/article under "The quantity will be changed to:", click the OK button on the right and have that update tableWarehouseData for the selected ticket/location/article immediately.
For example, if I selected ticket 1111A1, location 90003 and article 9326302909, 6 would appear as the current quantity. If I entered 77 and clicked OK, then 77 should become the new value for ticket 1111A1, location 90003 and article 9326302909.
Any help is appreciated!
Thank you!
Tony
