Results 1 to 5 of 5
  1. #1
    FJM is offline Competent Performer
    Windows 98/ME Access 2003
    Join Date
    Jun 2010
    Posts
    117

    Global update

    I have an established form which has several fields to describe a PARTNUMBER. It has hundreds of records
    I want to know if I can make the following changes.
    1. Add a new Combo field called PRODUCTCATEGORY - which will describe its type (A,B,C etc)
    2. Add a new Combo field called INSPECTIONLEVEL - which will describe the type of inspection required (NI,NII,NIII etc)
    3. Automatically fill INSPECTIONLEVEL by choosing a PRODUCTCATEGORY


    4. Is it then possible in the future to change ALL examples of a PRODUCTCATEGORY from one INSPECTIONLEVEL to another with a single click e.g CATEGORY A was LEVEL NII and I now want to change ALL CATREGORY A's to NIII

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    Yes to all. But the method of implementation depends on your data structure as well as the user interface form experience that you are wanting to provide.

  3. #3
    FJM is offline Competent Performer
    Windows 98/ME Access 2003
    Join Date
    Jun 2010
    Posts
    117
    Can you point me in a direction on how to do point 4. - the global change for a category level ?

  4. #4
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    that is an Update Query

  5. #5
    FJM is offline Competent Performer
    Windows 98/ME Access 2003
    Join Date
    Jun 2010
    Posts
    117
    Thank you - much appreciated

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

Similar Threads

  1. Global Variable
    By gtg430i in forum Programming
    Replies: 11
    Last Post: 03-10-2014, 05:00 PM
  2. Global Variables?
    By futurezach in forum Reports
    Replies: 4
    Last Post: 06-20-2013, 03:45 PM
  3. Global Property Changes
    By ajetrumpet in forum Code Repository
    Replies: 2
    Last Post: 08-07-2012, 10:31 PM
  4. Global variable
    By ramdandi in forum Queries
    Replies: 3
    Last Post: 12-18-2011, 01:01 AM
  5. Help Please - Global Vars
    By graviz in forum Programming
    Replies: 3
    Last Post: 02-18-2010, 10:36 AM

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