read data from another table

[Karen]

Hi all,
I'm working on a project to assign UPC numbers. The next UPC to use will be
stored in a table with one field, one record. On my form, I have a button
'Assign UPC', I want the code behind the button to read the next upc number
from that other table, add 1 to it and write it back. I also need to
remember the original next upc so I can write it to the Item file.
Can anyone help me out with this? I'm stuck in a big way.

Thanks in advance.
Karen

 

[Karen]

okay, I found out i can use Dlookup and get the data from that one field in
the nextupc table.
Now, how do I write back to that file and how do I write to the other file
(it's not Access, it's a SQL file that the database is linked to).

Karen