List Box & Subform -Recordset bookmark?

K

Kaoli

List Box subform
200601 content of 200601, 200602, 200603.....etc data
200602
200603

* 200601 = 1st record, 200602=2nd record ......

When i click record at bottom then the subform will list out then data, but
if i direct click on the list box(but record at below still showing 1 record,
but subform change the data base on which value i click) then i move to
subform will come out warning msg that i cant do that. How to make the record
at below auto go to watever value i click on list box?
Example
when i click to 200603 then recordset will move to 3rd record and subform
will come out data which belong 200603 and editable. then the database will
remember last value i clicked and after i close the form and reopen again
then recordset will maintance at 3rd recordset and same for the subform.

Thank you!
From Kaoli
 
Top