Hi,
a have a small problem with text field value. Let me give you a simple example:
I've created a table tblNameSurname with fields id, name, surmame. This is where I put actors details.
Second table is tblFilmCrew with fields id, surname. Field surname is a numer field linked with id from tblNameSurname. This table I use for choosing actors that have a role in a new movie. Whatever
For entering data to tblFilmCrew I use a form that is shown below:
It consists of a combobox 'surname' and a textbox 'name'. Although textbox is used just for additional information i want it to displaly an actor's name based on a surname choice. For this purpose I've created a combobox after_update event:
but unfortunately it doesn't work good - when a new actor is chosen all existing actors names change to a new-one name.
In this example, if I choose "stone" as a new actor, then all affleck, freeman and clooney names will be replaced with "emma".
Do you guys know how to fix it? Maybe there is a better and a more simple way to set textbox value based on combobox choice? Thank you!