Msg-box - choose teamnumber

[carstenhdk]

Hi




I have a table with students and their teamnumber.

I want a report, that shows the students from each team. The dream scenario is a msg box with a combobox coming up when the report is opened. Which team would you like to choose? Is that possible in a report, or do I need to use a quiry?



Thx

[pbaldy]

A straight input box is as simple as having a criteria of:

[Enter team]

Access will prompt for team. To have that be a combo box, you'll need to create a form with a combo, and have either have the query get the criteria from there or use this technique to open the report:

BaldyWeb wherecondition

[carstenhdk]

Ok, thx.


I can´t seem to get this right. Is this code line supposed to be placed in the reports OnCurrent sub or..?

[pbaldy]

Which code? The

[Enter team]

would be a query criteria, not code. The code from the link would go in the code opening the report, not in the report itself. Typically that would be behind a button, but could be anywhere.

[carstenhdk]

Why can´t I get this to work?! The msg box comes up as planned, but the criteria is not applied. When I type the teamnumber 1, it also shows 2,3,4... and so on. I have tried entering the criteria in the "filter" and the the "Where" feild. Nothing works.

[kimmer]

Create a query that includes the fields fromthe table, including team number.
In the grid, in the Criteria row for the Team number column, type:
[Enter team]
Run the query to test. If it doesnt work post back. If it does work, base your report on this query.