I am trying to construct a form to change the inventory status of items on the shelves. There are three fields; from left to right:
Item number Location Status
Under "location" and "status" fields, there are check boxes; when I enter a code into either or both of these fields, I can check the box so that it "freezes" the status. Any time I enter a new item number, for example, and "location" and "status" are frozen, the form automatically enters this value without having to manually enter it.
The idea is that I can lock those two fields and enter ONLY item numbers to change the status of a whole bunch of items at once.
The problem is that it doesn't work. I'm not much of a programmer, and the guy I asked to do this for me has been banging his head against the wall on this one.
Any suggestions as to how I might go about doing this? I can post the existing code, but I'm not sure how helpful that would be.
TIA, and sorry for such a lousy question.
Item number Location Status
Under "location" and "status" fields, there are check boxes; when I enter a code into either or both of these fields, I can check the box so that it "freezes" the status. Any time I enter a new item number, for example, and "location" and "status" are frozen, the form automatically enters this value without having to manually enter it.
The idea is that I can lock those two fields and enter ONLY item numbers to change the status of a whole bunch of items at once.
The problem is that it doesn't work. I'm not much of a programmer, and the guy I asked to do this for me has been banging his head against the wall on this one.
Any suggestions as to how I might go about doing this? I can post the existing code, but I'm not sure how helpful that would be.
TIA, and sorry for such a lousy question.