Unbound field providing filter criterior .....

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi All,

I have an unbound filed on the main form that provides the filter criterion
for a list that appears in a sub form. Criterion is typed in at the moment
(combo's will follow!) but I need to be able to enter a wildcard into the
abound field. I have tried * but it doesn't work.

Any suggestions please.

Ta.
Bill.
 
Hi Bill,

If you are using ado then you will find that the wildcard operator is
%.

If you need more help please can you give me same more detail.

Good luck,

Nick
 
No that does not help.

This is the query on the subform.

I want to be able to enter wildcard for officer="anyone"


SELECT [Discussion Notes].Counter, [Discussion Notes].Title, [Discussion
Notes].Officer
FROM [Discussion Notes]
WHERE ((([Discussion Notes].Officer)=[Forms].[Main Form].[Officer]));
 
Back
Top