Want to feed query a value from button

[Daisy509th]

I have a form that I open by a button that is feed by one query. I want to be able to click button and have it open the form but also feed the query a team name so that it only brings records for that team up in the form for adding and editing.



Not sure how to do this. I currently click button and it opens the form and brings up all the records in the tables for adding or editing. This much works.

So I need the form to have only the records specfic to the team listed on button

Thanks for any and all help

Here is a screen shot. I would like the button to be clicked and it open my one form to those team records. So i would have to feed the query the team name from the button somehow

[orange]

Hmmm?
If you plan on opening Form to a specific record, you might consider formA with a comboBox whose values are teamNames. That is, the rowsource for that combo on FormA is is a list of teamNames.

When a teamName is selected in the combo, a new form opens (or a subform or other construct) with the details for the Teamname that was selected.

I'm a little confused with the buttons etc.

[NTC]

To answer this question:

I need the form to have only the records specfic to the team listed on button

....and assuming you want to work with one generic form

Then you need a text field in your form. When you press the button - it writes the team into that text box.

Next it opens the form. So the button code is:

me.TextBoxName = "teamname"
docmd.openform etc etc

each button enters a different team name of course

The form itself is sourced to a single query. This query has criteria of that form's text box. In the team name field of the query - for the criteria you have:
Forms!FormName.TextBoxName

Once everything works you can make the text box on the form not visible if you wish.

[Micron]

A button per team, fed to the same query is not the way to go. Use a combo, and pass the user's selection. Having to add a button (or edit it) per team is bad design. You shouldn't have to modify your form based on changes in your data.