Results 1 to 3 of 3
  1. #1
    BigCat's Avatar
    BigCat is offline Vice Pres. of Napping
    Windows XP Access 2007
    Join Date
    May 2011
    Location
    Box Canyon
    Posts
    52

    Filling in Fields

    I have a table with the fields Model#, ProdLine, and StdHours. The last two are empty right now. I need to take the model number for each record, then I need Access to check the first two characters of the model number field, and depending on what the letters are it fills in ProdLine with the correct type of truck. For example( Model# = DR5252B001, so ProdLine = 'Drill Rig'). Is this even possible??

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Do you have a table that tells you that DR means Drill Rig or are you planning on hard-coding it into your query?

  3. #3
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    I would create a table that lists all the model numbers in one field and the ProdLine in another field. Then if you use a combo box to select the model number, you can then reference the column for the ProdLine in that control based upon the model number selection.

    Assume your table has three fields
    ID
    ModelNr
    ProdLine

    In your text box for the prodline you would put this formula
    =ModelNr.column(2) The ID has column 0 in your lookup SQL statement.

    Alan

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

Similar Threads

  1. Is there a way to do a query by filling in a from?
    By newtoAccess in forum Queries
    Replies: 6
    Last Post: 11-30-2010, 06:05 PM
  2. Auto Filling
    By tgavin in forum Forms
    Replies: 2
    Last Post: 08-02-2010, 10:47 AM
  3. Filling a table from a checklist
    By mr.wizzard in forum Access
    Replies: 3
    Last Post: 06-19-2010, 09:40 AM
  4. Automatically filling out a form
    By thorpef1 in forum Access
    Replies: 11
    Last Post: 01-04-2010, 07:20 AM
  5. Auto filling form fields
    By adamch29 in forum Forms
    Replies: 1
    Last Post: 07-25-2007, 06:22 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