Trying to run a query with input from a form, query works fine but the form doesn't

[offie]

I have a simple multifield search form. 2 unboud text boxes and a button to run the query.


What is happening is that it only runs the query and assumes the the input is * so all the data shows up.
I set the defualt value of the text input box as "" but when I type anything in the query still shows everything
Am I missing some way to link them?

I know that this is the problem becuase when I open the query without the form and I input the values asked for (format: [Forms]![Search]![CONum]) it works perfectly so somehow what I type into the form doest get transmitted.

I'm sure I'm missing something simple,
Thanks!

[rzw0wr]

try a requery after you input on the form.
Dale

[offie]

I tried that, I also close the query before hitting 'run query' in the form so that should be along the same lines?
It's like the 2 textboxes are being completey ignored.

[rzw0wr]

Please copy and paste your SQL for you query.


Dale

[offie]

Here it is:

SELECT co.ControlNumber, co.ContractNumber
FROM co
WHERE (((co.ControlNumber) Like [Forms]![Search]![ChangeOrderNumberB] & "*") AND ((co.ContractNumber) Like [Forms]![Search]![ProjectNumberB] & "*"));

[rzw0wr]

WHERE co.ControlNumber) =  [Forms]![Search]![ChangeOrderNumberB] ;

This is assuming that you form name is Search, and that ControlNumber and ChangeOrderNumberB are numbers.

Dale

[offie]

I don't get it should I replace what I had with your new code?

Control Number and ChangeOrderNumberB are both numbers

ContractNumber and ProjectNumbB are both text, does that mean I have to do something different?

Thanks!

Edit: I figured out I was putting in the label name instead of the text box name, but know while I get the numbers that I need, I get them an infinate amount of times so that access has to stop running the query because it exeeds 2gb. What in the world? I literally only changed the name

Edit2: Nevermind, its works now, thanks!

[rzw0wr]

Try this,

WHERE ((co.ControlNumber = [Forms]![Search]![ChangeOrderNumberB]) AND ((co.ContractNumber) =  [Forms]![Search]![ProjectNumberB]));

Replace you WHERE clause with this.

Dale