listbox/ combobox on a subform in Access

[Peter101]

I am having trouble to link a listbox on a subform (table) tot de main form (table). I would like to use it as an lookup list for the connected records. Already tried a lot but but it doesn't work :banghead:. Hope it makes sense.

Attachment zipped and stripped db: the main form = 1frmjongere and de the subform =1subfrmrapportage.


Sincerely.

 

[llkhoutx]

Use the selected ListBox row (assuming 1 column) value and in man form.

You have a bad design. The list box should be on the main form.

 

[Peter101]

Use the selected ListBox row (assuming 1 column) value and in man form.
You have a bad design. The list box should be on the main form.

Thank you for your reply, but I'm afraid is doesn't work. No value of the RowSource gifs a selection of the linked records. I always get all the 'child records' of all the 'parent records'.
A dataform does the trick, but you can't navigate the linked records of the subform (of a related table) with a dataform.
I have the code/ expression tot display the linked records in a listbox or combobox, but still you can't navigate the records,

I guess I simple question appears to be quit complicated :.

 

[llkhoutx]

This should help you with the bvalue of the listbox selection:

https://msdn.microsoft.com/en-us/library/office/ff835338.aspx

 

[JHB]

Why are you using a listbox and not the subform?