Requery subform from main form

[nswhit]

I have a text box and a combo box that are used to input criteria for a query. The text box is used to inut a value so that the query returns the top "N" records, the combo box further narrows the data. Those two controls are on a main form. On this main form, I also have a sub form whose source object is the query previously mentioned. Ultimately I'm trying trying to create a form where you input specific values into the main form controls, and the sub form populates with the data.



I have cmd button that runs the query great, however, I would like the sub form to update as well.

Thanks!

[rzw0wr]

Are the main form and sub form bound to each other?

Dale

[nswhit]

No. I've added a button that on click runs the query and then requeries the subform, however it only requeries the subform based on my second control (ignoring the top "N" records I would like returned as well). To make it more confusing, if i open the actual query on its own, it includes all the criteria inputed in the form (exactly how I would like the sub form to appear).

[rzw0wr]

You have 1 query with criteria from the main form.
You have the same query for the sub form.
You want the sub form to show the data filtered by the criteria from the main form.
The forms are not bound.

First I would try binding the forms.
And then I would try Refresh rather than Requery.

If this does not work upload your SQL.

Dale

[nswhit]

Correct. Didn't have much luck binding them. I think the problem exists trying to requery for the top "N" records. If I add a command to open report based on the query or open the actual query both display the accurate data, its just the subform that is not updating.

[rzw0wr]

nswhit,
We just stepped out of my skill level.
I am still very much a newbie with Access and this over my head.

Hopefully another member will step up and help you.

Sorry I could not be of more help.

Dale

[nswhit]

No problem, thank you anyways. Appreciated the quick response

[rzw0wr]

nswhit,
Send out PM asking for help.
I hate to leave you hanging.

Dale