How do I link list boxes to a record?

[Guest]

Doing child language development research; each of my participants has
his/her own record.
Using subforms, each with a record number that matches a record number on a
main form. Text boxes and combo boxes on the main forms and subforms work
fine, i.e., inputted data is "attached" to the correct record numbers. THE
PROBLEM IS: when data is entered into a subform's list box for one record,
the same data shows up for all records when I scroll from record to record.
I NEED to enter different data for each record from the list box....HELP!!!!!
What is the problem??? Any advice would be greatly appreciated.
-Jo

 

[Stefan Hoffmann]

hi Jo,

Using subforms, each with a record number that matches a record number on a
main form. Text boxes and combo boxes on the main forms and subforms work
fine, i.e., inputted data is "attached" to the correct record numbers. THE
PROBLEM IS: when data is entered into a subform's list box for one record,
the same data shows up for all records when I scroll from record to record.

This is normal for continues form, because Access uses some kind of
cloning mechanism to display the non-active datasets. This includes also
the data of a listbox.

I NEED to enter different data for each record from the list box....HELP!!!!!
What is the problem??? Any advice would be greatly appreciated.

AFAIK the only solution is to requery your list box in then on current
event, if the RowSource is hooked to a field or control on the subform
(master-detail relation):

Private Sub Form_Current()

lboControl.Requery

End Sub

mfG
--> stefan <--