>>>I am not sure how to ask this question.
>>>I am using a grid for data entry. the table is buffered. The user can edit many records. Save updates all changes.
>>>I am looking for the best way to tell if any field values were left empty on any record during ADD. Checking the current record is no issue. Doing a SELECT for empty field values always finds new record with empty values because the new values for the added record are in memory, hence the error message displays.
>>>Also does GETFLDSTATE 2 mean there is a value or does it mean the value has changed to a "value" or an empty value?
>>>How do I not get the record being added when verifying for empty values?
>>
>>Check this Re: GetNextModified kind of works Thread #941853 Message #943351
>
>That code looks good but it does appear to be able to get more than 1 modified record. I have had the user change several different record while they were "cleaning up" data. I cannot use GetFldState to verify any changes because an edit does not show as a change. Still not being able to find edited records. Am I over thinking this?

With the code to loop through GetNextModified records are you able to get all newly inserted records as well as any modified records?

For now in this loop just display some messagebox with one of the field from the record and see if you would be able to find all records what were touched/added.