Sort records in a form and dsiplay the result

[Guest]

I have a form with 2 subforms. It turns out now, that the data will be split
up among 4 groups, each to work on a certain segment of records. I have
created a query for each group to spit out into access.

However, now I think it would be good to hit a button and show the query in
the form view based on the query criteria.

Is there a fairly easy way to accomplish this?

Deborah

 

[John W. Vinson]

I have a form with 2 subforms. It turns out now, that the data will be split
up among 4 groups, each to work on a certain segment of records. I have
created a query for each group to spit out into access.

However, now I think it would be good to hit a button and show the query in
the form view based on the query criteria.

Is there a fairly easy way to accomplish this?

Deborah

Simply base the form on the query. Set the Form's Recordsource
property to the desired query.

If it's a Parameter query, you can use an unbound textbox on the form
itself to select which subset to choose. Use

=[Forms]![yourformname]![controlname]

as a criterion in your query, and requery the form in the control's
afterupdate event.

John W. Vinson [MVP]

 

[Guest]

Thank you very much! I thought it should be semi easy, but when I started
thinking about it, I couldn't visualize the answer.

Thank you again.

I

I have a form with 2 subforms. It turns out now, that the data will be split
up among 4 groups, each to work on a certain segment of records. I have
created a query for each group to spit out into access.

However, now I think it would be good to hit a button and show the query in
the form view based on the query criteria.

Is there a fairly easy way to accomplish this?

Deborah

Simply base the form on the query. Set the Form's Recordsource
property to the desired query.

If it's a Parameter query, you can use an unbound textbox on the form
itself to select which subset to choose. Use

=[Forms]![yourformname]![controlname]

as a criterion in your query, and requery the form in the control's
afterupdate event.

John W. Vinson [MVP]