slimpickens
New Member
- Joined
- Feb 17, 2002
- Messages
- 35
Is there anyway I can have a textbox register the next available number after each transaction is updated.
Thanks
Carol
Thanks
Carol
On 2002-04-09 10:50, slimpickens wrote:
My apologies,
I have a textbox(refnumber) on my Userform claim) in a wrksheet(Payments). I have made up a list of numbers in a next wrksheet(numbers) which I have in Column A beginning at row(2). There are other controls which would make up a claim transact"ion so that when I click on my "Add Record button all the data would be sent to the wrksheet(Payments). When my message box asks "do you want to add another record", I want the form to return with the next available number registered in textbox (refnumber) or if the user closes the form and reopens it, I want the next available number to be registered.
Hope this is enough info.
Carol