Results 1 to 4 of 4
  1. #1
    FJR is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jan 2018
    Posts
    10

    Need form so techs can update equipment location

    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?

  2. #2
    llkhoutx is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    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..

  3. #3
    FJR is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jan 2018
    Posts
    10
    Thanks for your help I will work on it I will post how it turns out.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870

Please reply to this thread with any new information or opinions.

Similar Threads

  1. text box location in form using VBA
    By Esmatullaharifi in forum Forms
    Replies: 7
    Last Post: 04-01-2015, 08:22 PM
  2. Replies: 3
    Last Post: 06-11-2014, 01:25 PM
  3. Open Form with set Equipment and max ID
    By JayRab in forum Programming
    Replies: 4
    Last Post: 01-24-2014, 02:17 PM
  4. Replies: 35
    Last Post: 01-08-2014, 01:33 PM
  5. Break up equipment order on form
    By zimzala20 in forum Forms
    Replies: 6
    Last Post: 08-15-2011, 03:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums