Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Quincy, Illinois
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Auto-Number a text box (Access 2003)

    I'm trying to auto-generate a unique id for an RFQ field (text - alpha numberic) in a form. I have the next unique id by doing a query, but I'm unable to get it inserted into the field when adding a new record. When setting the default value of the RFQ field to the query's output, I get a #Name error? I've also tried doing VB when the form opens, but with limited knowledge of VBA, I'm not able to get it working. Any help is greatly appreciated!!!
    (please let me know if I need to include more details)

    Thanks,
    Drew

  2. #2
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto-Number a text box (Access 2003)

    Drew

    Check out <post#=361840>post 361840</post#>

    HTH, John

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Location
    Quincy, Illinois
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto-Number a text box (Access 2003)

    Thanks...works great!

Posting Permissions

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