Bottom half of form not showing?

[christm]

Thanks for your help so far. I have a report within the database which is based on a query and the query has a parameter.
So when you open the report it asks for a value for this parameter.
I'd like this to be a LOV of all the distinct values in a column within a table.
I've tried adding things to the query like a Display Control of Combo Box, Row Source/Type of the table and row source of a bit of sql to bring back the values but it's not showing when I run the report, it's still just expecting the user to type in without any LOV.
Am I doing something wrong?



Thanks

Martin

[christm]

Also, taking advice from here, I'm trying to do Age as a calculated field.
I've went into the form and on the field properties of Age, changed the Control Source from the column Age to be 'DateDiff("yyyy",[Date of Birth],Now())'
But when I run the report, it's showing as #Name?

Am I doing something obvious wrong?

Thanks

Martin

[June7]

What is LOV?

I don't use query parameter input prompts. Can't validate the inputs which is what I think you are trying do. Review http://datapigtechnologies.com/flash...mtoreport.html


The age calc looks fine. Would have to analyze your report.

[christm]

Sorry - List of Values. New version of report with Age cal failing uploaded.

Thanks

Martin

[christm]

Age issue fixed - was missing an '=' sign at the start of the expression.

Within the report there is the following query:
SELECT [Player Details].[First Name], [Player Details].[Last Name], [Player Details].Age, [Player Details].Nationality, [Player Details].EU_Passport, [Player Details].Height, [Player Details].[Current Status], [Player Details].[Video Link 1], [Player Details].[Preferred Position], [Player Details].[Other Position], [Player Details].[Contract End Date], [Reports Details].[Scouted Date], [Reports Details].Club, [Reports Details].Opponent, [Reports Details].Division, [Reports Details].[Physical Comments], [Reports Details].[Technical Comments], [Reports Details].[Mental Comments], [Reports Details].[Overall Comments], [Reports Details].Grade, [Reports Details].[Scouted By]
FROM [Player Details] INNER JOIN [Reports Details] ON [Player Details].ID = [Reports Details].[Player ID]
WHERE ((([Reports Details].Grade)=[Grade]));


However when I run the query it doesn't ask me for a parameter (was expecting it to ask me for Grade).
It just runs the query, bringing back all records.
Shouldn't it ask me for the parameter input?

Thanks

Martin

[June7]

There is a field called Grade in the data source so Access finds it and uses it. The prompt must be something Access won't find, such as [Enter grade between 1 and 5].

I never use query parameter input prompts because can't validate entry.