Parameter Query w/3 Options...due YESTERDAY of course!

[Trevor G]

Lewis you made a very simple mistake. On your search form you have named each unbound textbox as FullName rather than txtFullName and also with the other unbound textboxes so in the query you are setting criteria to txtFullname but that doesn't exist.

If you had followed my instructions about using the expression builder to find the fields on the form this wouldn't have happened.

Please do the following:

Open your query in design view and each of the criteria where you have the Like remove the txt and the query will work as well as the form and the report will show you the correct information.

Attached is the same database sample with the query fixed.

 

[ALewis06]

Trevor: I thought I did follow your instructions but clearly I missed some things so I deserve that rap on the wrist. Many thanks

(I don't know how to mark this issue as RESOLVED.)

 

[ALewis06]

Now on to posting it on a Sharepoint site so that hundreds of users can view it and create their own reports. Something tells me I'll be back.