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
    Messages:
    1
    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:
    226
  2. csuerun
    Replies:
    0
    Views:
    219
    csuerun
    Feb 18, 2004
  3. Guest
    Replies:
    1
    Views:
    235
    Dirk Goldgar
    Apr 13, 2006
  4. Guest
    Replies:
    8
    Views:
    569
    strive4peace
    Apr 13, 2007
  5. Martin

    Report page number same as Form record number

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

Share This Page