List/Subform Update

[EssexRob]

I have a private sub on a subform called txtsearchstring_change.

The txtsearchstring box is = to the client_id on the main form.

Basically when the user clicks on the next record button (which is on the main form) it should update the txtsearchstring_change on the subform and then display the new results in the list box.

Im not to sure how to do this. I understand im calling a sub from another form, so i did try a public not a private sub. And i have added on the next and previous button - txtsearchstring_change.

Thanks for any help.

 

[Laoujin]

If your subform is called sfcMySubForm you can access the field with:

Me!sfcMySubForm.Parent.Form.Controls("txtSearchString").Text = Me!Client_Id

 

[EssexRob]

Thanks for the help. It didnt appear to work, little difficult to explain.

txtsearchstring appears on the subform this is = to client_id.

The listbox displays a query showing all jobs related to the client.

When i click on the next client button the textbox "txtsearchstring" does update to match the client_id, however the listbox results do not update.

Previously on a single form this worked when the code was:

DoCmd.GoToRecord , , acNext
TxtSearchString_Change

Thank you for the help