ScoobyNet.com - Subaru Enthusiast Forum

ScoobyNet.com - Subaru Enthusiast Forum (https://www.scoobynet.com/)
-   Computer & Technology Related (https://www.scoobynet.com/computer-and-technology-related-34/)
-   -   Access Question (https://www.scoobynet.com/computer-and-technology-related-34/208586-access-question.html)

Mark Pirks 13 May 2003 10:41 AM

I'm trying to use a form to run a "Like" filtered Query but nothing seems to work

I have a data table with a list of descriptions
I have a form with a combo list drawn from the grouped list of descriptions (Called Description)
I have a querry which filters the data table based on the combo list

I've tried (In criteria) Like "*[Forms]![Filter agent Names]![Description]*" and it doesn't work

I've tried using the "*[Forms]![Filter agent Names]![Description].[value] / [text]*" Neither work

I've tried incorporating Val() and Eval() - neither seem to work (Might be using Eval() wrong entered Like "*Eval([Forms]![Filter agent Names]![Description])*"

Can Anyone help


All times are GMT +1. The time now is 10:40 AM.


© 2024 MH Sub I, LLC dba Internet Brands