Access Data Page not showing results

[coolkake]

All

I have a query for my data page that has the following Criteria for a person name

Like "*" & [Enter Name] & "*"

When I run the query it works fine but when I try it in the data page I do not get any results. When I remove this from the criteria I get all the results.

I have used this criteria in a few pages before and it's worked fine but the one thing that is different about this is the field has a Combo Box as the Display Type and the Row Source Type is a Value List in the table.

Any input on this would be great as I have spend the better part of today trying to figure this out with no success what so ever

Thanks

Kake

 

[PHV]

Have a look here:

http://www.mvps.org/access/lookupfields.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[coolkake]

Thanks PH

If I'm reading this correctly what I want to do will not work unless I take out the Combo Box and Value list from the table?

That is really good information for me to know going forward but is there a quick work around for this? All I'm looking for is a way for the user to enter a persons name and only show in a data page the information for that person.

Kake

Great site you sent me to BTW, already bookmarked it I have never seen articles/tips written as well as that. I will learn a lot from this site.