Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    35

    Unanswered: generator of auto number

    I have a form with a combo box that have 5 option to select. I need that if the person select the first option exmaple: LAN(L), then the txtIDNo. = L001, if the person select the option 2(example:PLC(P)) then the txtIDNo= P001 etc...

    The problem is that each IDNo. is incremental:

    L001 P001
    L002 P002
    L003 P003

    .... .....

    each record heve a IDNo. that identy the recor depending of the option that select in the combobox. Please if any people can help me, thanks!!!!

  2. #2
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Red face

    Hi,

    If you could Zip and Attach a sample of your DB I would be willing to take a look to see if I can solve your problem for you.

    Bud

  3. #3
    Join Date
    Mar 2004
    Posts
    35
    Okey, I add a database. THnaks for you help.

  4. #4
    Join Date
    Mar 2004
    Posts
    35
    SystemLibrary.mdb
    Attached Files Attached Files

  5. #5
    Join Date
    Mar 2004
    Posts
    35
    In the form: Data Entry I need if the combo box System is LAN, THE IDNo. is L001(example)...L00002...L00003, IF the option is PLC the IDNO ...P00001...P00002 ETC.

    tHE COMBO BOX HAVE FIVE OPTION . THANKS FOR YOU HELP.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •