combobox first field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Abrm said:
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?
Click to expand...

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).
 
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.

Rick Brandt said:
Abrm said:
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?
Click to expand...

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).
Click to expand...
 
Back
Top