Form Data Not being passed onto query

[fmoses]

This is probably pretty basic, but i can't seem to figure out where i am going wrong with this.



I have created a form which an individual can use to enter search information and on enter it will run the query passing on the information. I first created one with comboboxes and worked great. I am now trying to create one using text fields, but for some reason it's not either passing on the data, or something is not working right, and can't figure out why. Please see the attached picture.

The expression I am using in criteria of query is
Like [Forms]![srchportalpi]![Last_Name?] & "*"
I also tried adding a Null statement thinking that if there were any blank data it was causing a problem
Like [Forms]![srchportalpi]![Last_Name?] is Null
But that didn't work either.

If i run the query by itself without the form, and entering the data using the prompts it seems to work fine, but when i enter the data on the form, and then run the query it returns all files in the database. I'm not sure if the issue is with the form (which i think it might be due to query working fine without the form) or the query setup. Any suggestions? Let me know if you need any more info and i'll post it. thanks in advance.

[dcrake]

Take a look at the sample database I posted regarding passing public variables between forms/queries and reports. This might help your with your problem.

David

[fmoses]

Take a look at the sample database I posted regarding passing public variables between forms/queries and reports. This might help your with your problem.

David

Thanks for the reply, although your solution is interesting, I think it is more than what is needed for me at this time. The problem just seems to be when i'm using unbound text boxes to capture the data, as when i use combo boxes and type it in using that it works fine. Unfortunately I was hoping to just use text boxes if possible.