Use second column of a combo in a query

[irade92]

My combo in a form has three column. First column I use as Criteria in a query in the field Invoice, How can I use second column as Criteria in the same query in the field Date. Very often happens two invoices with the same number but different date. I need to separate this invoices
Please help

 

[boblarson]

You can't use anything but the bound column in a query. You can put a hidden text box on your form which references it in its control source and then use that text box as your criteria for the date field.

In the control source of the text box use

=[ComboNameHere].[Column](1)

1 is the second field because it is zero based.

 

[irade92]

You can't use anything but the bound column in a query. You can put a hidden text box on your form which references it in its control source and then use that text box as your criteria for the date field.

In the control source of the text box use

=[ComboNameHere].[Column](1)

1 is the second field because it is zero based.

Very wise..thanks...I understand it

 

[irade92]

Very wise..thanks...I understand it

This is what happens...the numbers of Invoices are one below other and the dates are different...I use a hidden fields as a criteria but it gives me the first date above...not the date of a column...if I choose another invoice it is OK...but not with the same number of invoice..Very strange...

 

[boblarson]

So you are really looking for a second ROW and not a column, correct?

 

[irade92]

So you are really looking for a second ROW and not a column, correct?

NO..I need second column but the value of the current row, but it gives me the value of upper row..It happens only if the invoices are the same, if not, everything is in order..

 

[irade92]

NO..I need second column but the value of the current row, but it gives me the value of upper row..It happens only if the invoices are the same, if not, everything is in order..

I tried with three same numbers of invoices and three different dates but always gives me the values of the second column but first row..How can it be?