How to Suggest a number

I am connecting to a database and would like to autosuggest the next message code in a text box. Any suggestions how this can be done?

Use an AutoNumber field in your table.