I wish to write some code that will:
- search the form's table when the form is opened;
- find the first record in the table where a specified field is empty, then;
- populate a set of text boxes with the data from each of the fields in the record
I am guessing that this can be achieved with a SELECT statment in one of the form's property boxes but I'm unsure which property box to use and how to construct the statment.
Can anybody suggest how I might go about this?