>>>I have an application that involves hearing tests on individuals in a noisy evironment. There may be several tests over the years. These tests are recorded in a table, which I search through when adding a new record to see if that person's SSAN exists in the table. There are a number of fields which I would like to get from a previous record (first name, last name, middle initial, dob, race, sex, height, department, etc.) I know that I could do a SET CARRY (field list), but in this case I am not appending immediately. What would be the best way of grabbing several fields from an existing record and replacing the values in the form?
>>
>>You can use SCATTER and GATHER in this case
>
>I thought about that, but the table field names might be FNAME, LNAME, etc. The form text boxes have names like txtFname, txtLname, etc. Plus, as I understand the way forms work, the append does not occur until I save the information. So the GATHER would over-write the current record.

Oh, I see what you mean.In this case you need to store each field content into textbox.value through some custom routines.
BTW, APPEND in form will work that way you want it, I mean you can do APPEND BLANK when you press Add button, or INSERT INTO when you press Save...