Hey all, just have a quick problem.

I'm working on an Access form that has a subform. I need the subform to pull some information from another database table, but in order to do that, I need to make some dynamic query statements, using variables from the main form. I'm unsure how this can be done. There are plenty of sites online that explain how to get variables from the subform to the main form, but I haven't found any that are vice versa.

Can anyone give me an example? Thanks in advance!