Preload a text box field in a data entry form
Posted on 2008-11-06
I'm building a form to enter a new record in a table. The records in the table have a key which was manually entered (not autonumbered). To create the next number, I run a little query which finds the maximum key value and then adds one to it. It is this value that I want to preload into the data entry form. Then when the data entry form is completed an closed/saved a logical number is placed in the new record's key.
I've done this other places with a combo box, but don't see how to do it with a simple text box.