ms access - Updating a sub-form based on a list box selection -

ms access - Updating a sub-form based on a list box selection -

first of want have read other questions similar 1 don't solve issue.

i have form contains sub-form. master form has list box displays entries in table (only showing 3 fields though) , sub-form designed show info associated record selected in list box.

i have set link master fields , link kid fields clientid (the table client information). when first open master form sub-form displays info first item in list box when select different item in list box sub-form not update. have tried using requery vba method without much success.

does have hints @ all?

set link master field name of listbox. ensure listbox returns client id.

for example

row source : select clientid, clientname table bound column : 1 column count : 2 link master fields : mylistbox link kid fields : clientid

now, when user selects client listbox, subform update info client.

ms-access ms-access-2000