I need to make a form so that my techs can update the field in a table when they move equipment from one room to another room. Don't know how to get started?
I need to make a form so that my techs can update the field in a table when they move equipment from one room to another room. Don't know how to get started?
Bind the table containing the equipment (decsriiption or specification) and it's location to a form. Use a combo box with a list of all possible locations, updateable on-the-fly, to specify or select the new location; on the "after update event" of that combo box, store the new location where appropriate..
Thanks for your help I will work on it I will post how it turns out.
You may get some ideas/information from this thread and dialog.
For more info on database planning and design.
Good luck.