How can I refresh a subform after a combobox item is selected on my main form in access?

I have a subform that displays a bunch of dimensions for whichever part is selected from a dropdown on the main report..

Their are two dropdowns in the main report; JobNum and PartNum.. PartNum is tiered from JobNum so that when you select a job only parts from the selected job are listed in the PartNum combobox.

So I then have a subform that displays all the dimensions associated to that part that is selected. It will update only if I hit the F5 key after I select the Part in that combobox.

What can I do to make that subform automatically update after I select the part in the part combobox?

Thanks in advance for the help!
LVL 2
Jarred MeyerProduction ManagerAsked:
Who is Participating?
 
mbizupConnect With a Mentor Commented:
Try this in your combo's after update event:

Me.MySubformControlName.Form.Requery
0
 
Jarred MeyerProduction ManagerAuthor Commented:
That did the trick!

Thanks
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.