I have records with a 3 part key. A user would like to be able to change the last key field and keep the current record information, however this creates a new blank record. Any advice???
Do I need to write code in the Form's Read event to determine if
the key fields have changed. Any suggestions would be helpful.
I know RevG and I think Arev had system code that would say
you've changed the record, would you like to delete the original
record.
Thanks….
Steve C.
Steve,
I would probably put the code in the READ event to see if only the last part of the key ID was changed. If so, and the record is new, then update all the controls with the contents of the previous record. For this you would need to store the record somewhere like a user defined property so it can be accessed after the record has cleared. You also may want to check out Dave Pociu's utility for updating your forms with information from a record. He designed to simulate the ease we had in AREV of simply updating @RECORD and having our windows reflect those changes.
I did a search on Pociu but couldn't find anything about
the utility you discussed. Can you tell me where I can
find it?
Steve C.
Steve,
Read this.
Steve,
Whoops, the link must have been broken during edit. See if
this works. If not, then do a search for "Pociu AND conference", it will be one of four I believe.