>>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.
Duty is ours, the results are God's - John Quincy Adams