My solution always requires table buffering.
>VFP 6.0 (SP4)
>
>I have a Primary key in a table. The reason is it can not have any duplicate ID. Oddly that it only checks AFTER leaving the RECORD, not after leaving the FIELD itself? It doesn't sound right, since it sometimes gives the error message (of dupe ID) right away upon leaving the field itself (but remain in the same record) and other times it doesn't? That ID field is INPUTTED by the user.
>
>Whatever the case is, I need to check for the ID before can proceeding with the data entry. So, in the form, where in the field text property would I put the "=TableUpdate()"?
>
>If there is a better way to do it, please let me know. So far, I have all fields disabled until the ID is non-dupe, then enable the rest of the fields (for inputting other data).
>
>Chuck
Mark McCasland
Midlothian, TX USA