combobox first field

[Guest]

I have a combobox based on a qeury

Qeury looks like:
reference, article, decription, etc., etc.
bound column = 2

I want to search on reference, by typing the first letters.
But in the combobox I want to store the article number, because in my code I
use table![field] = me.combobox

But know it saves the reference and not the article.
How can I do this?

 

[Rick Brandt]

I have a combobox based on a qeury

Qeury looks like:
reference, article, decription, etc., etc.
bound column = 2

I want to search on reference, by typing the first letters.
But in the combobox I want to store the article number, because in my
code I use table![field] = me.combobox

But know it saves the reference and not the article.
How can I do this?

DoubleCheck your SQL and BoundColumn setting. If it is (2) then the second
column should be the one getting saved.

Your field in the table is not set up as a Lookup field is it? If so
eliminate that as it causes you to see one value in the table when it is
actually storing another (bad idea at the table level).

 

[Guest]

as you describe it is working correctly, only I want something different.

I want to search and type on the reference, but after the search I want the
article number in the combobox.

I have a combobox based on a qeury

Qeury looks like:
reference, article, decription, etc., etc.
bound column = 2

I want to search on reference, by typing the first letters.
But in the combobox I want to store the article number, because in my
code I use table![field] = me.combobox

But know it saves the reference and not the article.
How can I do this?

DoubleCheck your SQL and BoundColumn setting. If it is (2) then the second
column should be the one getting saved.

Your field in the table is not set up as a Lookup field is it? If so
eliminate that as it causes you to see one value in the table when it is
actually storing another (bad idea at the table level).