Search criteria

[GinaWhipp]

Glad you finally got it working... and that's what we're for, you ask we answer!

 

[DevTycoon]

I have tried Allen Brown method and uncle Gizmo. The only difference is Allen uses a set filter command and uncle gizmo uses a record source command on the control. Both work well but break the same way when used a certain way..................Suppose someone typed the entire string in for the Surname organization and program title. No results appear. Its like the wild card does not like it when you input the entire field value.

I need the user to be able to type in the entire field value or a portion of the value and have all results populate. :banghead: :banghead::banghead:

 

[vbaInet]

I have tried Allen Brown method and uncle Gizmo. The only difference is Allen uses a set filter command and uncle gizmo uses a record source command on the control. Both work well but break the same way when used a certain way..................Suppose someone typed the entire string in for the Surname organization and program title. No results appear. Its like the wild card does not like it when you input the entire field value.

I need the user to be able to type in the entire field value or a portion of the value and have all results populate. :banghead: :banghead::banghead:

Perhaps you can create a thread of your own (instead of hijacking someone else's) and we can look into it for you. And please when you do, give more information like showing us the SQL statement you wrote.

 

[DevTycoon]

Perhaps you can create a thread of your own (instead of hijacking someone else's) and we can look into it for you. And please when you do, give more information like showing us the SQL statement you wrote.

My apologies.

 

[vbaInet]

It just helps to get your question answered quicker. If we see new threads we tend to follow-up those threads quickly. And although your problem may be related to this one, the original poster may get confused and he/she will keep getting notification e-mails when a message is posted.

When you create your thread it would helpful if you could post a link to this thread so we know where to reference