query criteria

[mike02]

hey all,



Im searching from a combo box (3rd column) in subform:

the combo box has three columns, two IDS, companyID, CompanyNAME, OrderID,

I have it searching fine in the with the Company ID, with this:

[Forms}![frmorders].[Form]![cboselectcompany]

how do i specify to now search on a different column?

Cheers

[rpeare]

[Forms}![frmorders].[Form]![cboselectcompany].column(x)


where x starts at 0, the first column of any combo box or list box is 0 and increments by 1 from there.


However, this doesn't always work (depends on how you are trying to apply it). If you're doing it within vb script it shouldn't be problematic, if you're doing it in a query it *may* be a problem depending on your version but you can try first and see what happens.

[mike02]

wouldnt work, but i got around it by creating a textbox, to then display the value of the OrderID, works now, thanks for thehelp