I've got a table (order), each record got by autonumber his own orderID. Then I got a form with all the records of this table. All this records got a factID this ID is "0" till i've send the bill of that order. What I want is when I got the form on screen, select one order then the module give the record his own factID(=max(factID)+1) and then give the preview of that bill. And also the select all the records with factID="0" and by buttonclick give them all there own factID(which is each time Max+1) and show the preview of that bills. I'm looking weeks for this and I really want to know if it's possible. Thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Generate ID by VBA
- Thread starter Kweker
- Start date
Similar threads
- Locked
- Question