Get a number from a table to a form.

Discussion in 'Microsoft Access' started by BCrums, Aug 1, 2012.

  1. BCrums

    BCrums

    Joined:
    Aug 1, 2012
    Likes Received:
    0
    Hello! I am trying to pull a shipping number from a database table, Shipping, to a form, increment the number for the set of items to be shipped, and add the new items back to the database. I am trying to use DLookup like such:

    txtShipNum.Text = DLookup("Shipping Number", "Shipping", "ID = 52")

    but it doesn't seem to find "Shipping Number" even though that is the collumn name. I need to pull the last shipping number from the database in one form and increment it to one more, and then push that new number to a subform where I input my data for shipments. Does anyone have any suggestions?
     
    BCrums, Aug 1, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Dan
    Replies:
    6
    Views:
    309
  2. csuerun
    Replies:
    0
    Views:
    250
    csuerun
    Feb 18, 2004
  3. Guest

    how do i make a phone number in a form/table

    Guest, Nov 5, 2004, in forum: Microsoft Access
    Replies:
    2
    Views:
    283
    Van T. Dinh
    Nov 5, 2004
  4. Guest
    Replies:
    1
    Views:
    280
    Dirk Goldgar
    Apr 13, 2006
  5. Guest
    Replies:
    8
    Views:
    671
    strive4peace
    Apr 13, 2007
  6. muster
    Replies:
    2
    Views:
    246
  7. inetgnu@gmail.com
    Replies:
    5
    Views:
    399
    Tony Toews [MVP]
    Mar 27, 2007
  8. Martin

    Report page number same as Form record number

    Martin, Jan 7, 2008, in forum: Microsoft Access
    Replies:
    1
    Views:
    262
    Larry Linson
    Jan 7, 2008
Loading...