Synchronize single form to a List.Box

[FuzMic]

Friends

I have a List.Box side-by-side a single form. The Row.Source of the List.Box and the record.source of the single.form SELECTS from the same table. This way user can see all the possible records underneath the exposed single.form.

By a simple event, eg Double.Click on the the selected item on the List.box, msAccess cam picks up its details which i can THEN use to find the same record underneath the single.form. This my way of synchronizing the list.Box with the single form.

My problem is i don't know how do vice versa. What i hope is whenever the single/form change / arrive at a new record, the list.box points to the same record. I WAS tinkering with recordsets but get no where.

Appreciate some help from my gurus.

 

[moke123]

If i am understanding your question correctly, you have a form with a listbox on it. Your using a findfirst and bookmark code to display a record on your form. You also navigate through the records somehow, however when you do you would like the line in the listbox to be highlighted for the current record.

if thats the case I believe you can use the form current event and code

Me.MyListboxName = me.MyPrimarykey

substituting your listbox and Fieldnames

 

[FuzMic]

123 you get my problem quite rightly. THANKS. Will try your 123 with the Name of list box and the keyFieldName of the singleRecord.frm.

 

[FuzMic]

moke, must thank you again as it just simply worked without a hitch. Because i never thought about it this way, i appreciate very much your pointer. Kind Ragards.

 

[moke123]

Your welcome and good luck with your project.