Results 1 to 2 of 2
  1. #1
    eyeseven is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    1

    Add Character to autonumber in a form according the type selected.

    I have a form used as our reference number for several documents.

    here is the form :



    Click image for larger version. 

Name:	form.jpg 
Views:	12 
Size:	38.6 KB 
ID:	8707

    I need to add letter to the reference field according to the type selected. like if i select Letter, letter "L" will be added to the reference number, and if i select Quotation letter "Q" will be added (EDSCO/1114/Q).

    Hope you guys can help me with this things..

    regards,


  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It looks like it is just concatenation code in the AfterUpdate event of the ComboBox or maybe the Save/Update command button. What is the problem you are having?

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

Similar Threads

  1. Autonumber form and subform question
    By Helen269 in forum Forms
    Replies: 1
    Last Post: 02-05-2012, 11:27 AM
  2. Creation of autonumber on open form
    By Pragmatic in forum Forms
    Replies: 1
    Last Post: 12-17-2011, 11:39 PM
  3. Replies: 16
    Last Post: 10-13-2011, 07:52 AM
  4. Replies: 1
    Last Post: 08-17-2010, 02:33 PM
  5. Replies: 2
    Last Post: 03-18-2010, 08:24 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