Get a number from a table to a form.

B

BCrums

Joined
Aug 1, 2012
Messages
1
Reaction score
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?
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Negative Numbers 5
Using ID field to select linked table record 2
New Data to Mulitple Tables 5
Please offer your thoughts on the best way to set this up . . . 3
selecting a single record 6
Inventory/Sales/Warehouses 6
I need a freight forwarder in the UK 5
Create a linked table 10

Top