Linking main form to subform

I have an access form that allows the user to search for a customer. I called it frmSearch.
The form has a subform which I called frmSearch_Subform .  

The idea is that if the customer clicks on the customer in the listbox, the subform loads the detailed data.

How do I link the unbound subform with the main form?
I tried with me.subform.frmSearchDetail .. but it doesn't work. Maybe because frmSearch_Subform used to be called with a filter?

I would appreciate it if someone could help me make this link from the main form to the subform.

Thanks
ShoppingTaxi-EE.accdb
Massimo ScolaAsked:
Who is Participating?
 
John TsioumprisSoftware & Systems EngineerCommented:
Well there are a number of ways ..here is one
By the way i had to delete and recreate your subform because i was getting a strange error....just rearrange the fields...
ShoppingTaxi-EE.zip
0
 
Massimo ScolaAuthor Commented:
That worked. Thanks a lot.
The issue must have been with the subform .. when I recreated it I was able to access it.

Appreciated your help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.