Combo Box -- shoot me please (Elizabeeeeth..... DoooouuuggggP)

[Dumboy]

Ok. so I created a form named Form1<br>in the form I created a combo box named Combo0<br><br>So I open the query and in the criteria section I typed<br><br>Forms!Form1!Combo0<br><br>So, I'm all happy and singing and jumping all over the office (you know all happy and all). I try to open the query and ..... I get the little blue box that asks to ENTER PARAMETER VALUE. I could not believe my eyes....<br><br>What am I doing wrong lord.........<br><br>I tried with square brackets... and still same result.. same old result...<br><br>could you explain to me really slowly what is the logic behind the scenes...?<br><br>Thanks ... <p>Dumboy.! Ouch.! .my brain.....<br><a href=mailto:spiderdesign@yahoo.com>spiderdesign@yahoo.com</a><br><a href= > </a><br>It's hard to think with only one neuron......Ouch.....!....it hurts when I think......!

 

[Andreu]

Beg your pardon, my english is very poor.<br>create one button in form1 and assign the query in the onclik event

 

[DougP]

Well is your form called &quot;Form1&quot;<br>i.e. Forms!Form1!Combo0<br>Change Form1 to your form name<br>And save the form before you can reference a new item on it.<br><br>

 

[elizabeth]

And after you save the query (under that same name that you refer to it by&nbsp;&nbsp;- Andreu &nbsp;&nbsp;please pardon the dangling participle)&nbsp;&nbsp;be sure the form is <b>open</b> when you refer to it.

 

[Dumboy]

Andreu... Merci mon ami.... It worked<br><br>DougP.... thanks<br><br>Elizabeth.... marry me...!<br> <p>Dumboy.! Ouch.! .my brain.....<br><a href=mailto:spiderdesign@yahoo.com>spiderdesign@yahoo.com</a><br><a href= > </a><br>It's hard to think with only one neuron......Ouch.....!....it hurts when I think......!