Hi,
I'm trying to make a form to keep track of work orders. I want to be able to "check in" "check out" work orders.
right now what i have is a sheet with two columns A: Work Order Numbers and B: Location
What I want to do is click and option button (check in or check out) and then type in the work order number in a text box, click go and be prompted for the location. The work order number is then looked up and the location is added beside it.
I haven't a clue how to do this, some help would be greatly appreciated. I can't seem to find anything in the forum that does this, my appologies if it does exist and i just couldn't find it.
Cheers,
Ami