searching

[Ravislayer]

I have a cross tab query set up which iwould like to search for a criteria which is input by a user. i have a form set up which includes a command button and a text box. I have been trawling through the Help but cannot find a solution, other than i need to use a parameter query, how do i set one of these up?

 

[Tiro Cupidus]

I think I remember having a problem setting a parameter on a crosstab query the normal way. However, a way I know will work is, in the query, add the field with the criteria you want the user to specify. I'll use my example here. In the criteria, I have a call to a function fInputBox("FY"). The function is simple:

Function fInputBox(message As String)
   fInputBox = InputBox(message)
End Function

Then whatever they type in the input will be put in place of the function call.