Re query subform

[cbuechner]

Ok, I thought I had this, but I am missing something.

I have a form called lab. On the subform, there is a subform that displays data that is query. The query results are a direct result of the data from the main form. I would like the subform to update as a result of the values the user is entering into the main form.

I tried

Me.Requery

But this resets the main form. Im researching, but cant figure this out.

[cbuechner]

Sorry...on the main form "lab" there is a subform.

[Micron]

see if you can figure it out (& maybe bookmark this page)

http://access.mvps.org/access/forms/frm0031.htm

[cbuechner]

Not understanding it. I'm trying everything I can

[Micron]

Try Forms!MainFormNameHere.SubformControlNameHere.Form .Requery

or if the code is on the main form, can use

Me.SubformControlNameHere.Form.Requery

Other syntaxes may work but I find neither of those has ever failed to work, unless you have a navigation form. That is a different animal.
Your subform control name might be the same as the form you're using as the subform. I don't allow that.