tanolalano
Technical User
Hi all,
In a continuos SubForm, record are added by 3 listbox in the tblUnion.
So the 3 listbox are populated depending what selected in each one (linked listbox).
I use the ".Requery" to populate the listboxs in After_update event.
If the listboxs store the value of PK (boundcolumn 1) in a numeric field of the tblUnion when i go to new record and select an item of listboxs, the listboxs in the previous records change as i select in the last record. I know that the stored value is correct, but i need see all records in corrected ways.
I try another solution, if the listbox store value of text (BoundColumn 2) in a text field of the tblUnion, selecting items in listboxs of last record don't change the value of previous records.
This is what i need, but i'd like to store the PK in the tblUnion.
Why occur this?
There are some codes to put in Afterupdate events to bookmark previous selected records?
Thanks in advance
In a continuos SubForm, record are added by 3 listbox in the tblUnion.
So the 3 listbox are populated depending what selected in each one (linked listbox).
I use the ".Requery" to populate the listboxs in After_update event.
If the listboxs store the value of PK (boundcolumn 1) in a numeric field of the tblUnion when i go to new record and select an item of listboxs, the listboxs in the previous records change as i select in the last record. I know that the stored value is correct, but i need see all records in corrected ways.
I try another solution, if the listbox store value of text (BoundColumn 2) in a text field of the tblUnion, selecting items in listboxs of last record don't change the value of previous records.
This is what i need, but i'd like to store the PK in the tblUnion.
Why occur this?
There are some codes to put in Afterupdate events to bookmark previous selected records?
Thanks in advance
