parameter query

  • Thread starter Thread starter Fay Yocum
  • Start date Start date
F

Fay Yocum

I have a form where I select departments and credentials from two subfroms.
This works well. I have one combobox to select a class. That works well. Now
the issue. I want to use a text box to be able to restrict the search to
find partial strings. For example I have several different versions of
classes on Pressure Ulcers some were lecture others independent studies. I
used the following criteria on the query grid

Like "[Forms]![frmAttendanceRecords]![txtClassName]*" Then used Pressure in
the textbox. That doesn't work

I also tried it with the asterisk in the textbox instead of in the QBE.
Didn't work.
I also tried using the Like "Pressure*" in the text box and just the []
section on the QBE. Didn't work.

Any ideas. Thank you for your help.

Fay
 
This worked! Thank you. When I said didn't work I mean no records of classes
were displayed with the names.

This step is under control now. Thanks Fay




Jeff Boyce said:
Fay

Did you try

Like [Forms]![...]![...] & *

Good luck

Jeff Boyce
Access MVP>

Fay Yocum said:
I have a form where I select departments and credentials from two subfroms.
This works well. I have one combobox to select a class. That works well. Now
the issue. I want to use a text box to be able to restrict the search to
find partial strings. For example I have several different versions of
classes on Pressure Ulcers some were lecture others independent studies.
I
used the following criteria on the query grid

Like "[Forms]![frmAttendanceRecords]![txtClassName]*" Then used Pressure in
the textbox. That doesn't work

I also tried it with the asterisk in the textbox instead of in the QBE.
Didn't work.
I also tried using the Like "Pressure*" in the text box and just the []
section on the QBE. Didn't work.

Any ideas. Thank you for your help.

Fay
Click to expand...
Click to expand...
 
Fay

It occurred to me that I have no idea what YOU mean by "didn't work". Do
you mean it returned no records?

Jeff Boyce
<Access MVP>
 
Back
Top