combo box and queries

P

Pat G

I believe Combo boxes have columns 0 being the first
column.

Code: 
.itemdata[0] is the first column
[code].itemdata[1] is the 2nd column

is your query pulling the right column?
[QUOTE]
-----Original Message-----
I have a combo box on a form called code.  In the query[/QUOTE]
I set the criteria to [forms]![form1]![code] where form1
is the name of my form.  It reterns nothing.  When I
manually type in the value i selected on the form it runs
fine.  What am i doing wrong.
 
Top