Access Question
#1
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
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
Thread
Thread Starter
Forum
Replies
Last Post
Brzoza
Engine Management and ECU Remapping
1
02 October 2015 05:26 PM