J
Julia82
Hello guys,
The thing is simple but at the same time complicated.
So, the thing is i have a COMBOBOX (combo10) and a TEXT BOX (textbox33) on a
form (Form1).
The COMBOBOX gets the "Row Source" from a table (Table1).
The table has the following valuses:
ID Field1
1 a
2 b
3 c
The COMBOBOX has the following macro:
SetTempVar
Name: MyVar
The TEXTBOX has the fllowing "control source":
=[TempVars]![MyVar]
Expression: [combo10]
So, when I run the Form and I select let's say value "a", instead of showing
in textbox33 the value "a" how I want, it's shwing me the value "1", when
selcting value "b", it's showing value "2", and so on, representing the ID,
instead of the Field1 value.
What do I do wrong?
All I want is when I select value a in the combobox, to show this value in
the textbox.
The textbox is on another form, that opens after this one closes, so the
value must be ... I gues a TempVar.
Thank you very much for your help!
The thing is simple but at the same time complicated.
So, the thing is i have a COMBOBOX (combo10) and a TEXT BOX (textbox33) on a
form (Form1).
The COMBOBOX gets the "Row Source" from a table (Table1).
The table has the following valuses:
ID Field1
1 a
2 b
3 c
The COMBOBOX has the following macro:
SetTempVar
Name: MyVar
The TEXTBOX has the fllowing "control source":
=[TempVars]![MyVar]
Expression: [combo10]
So, when I run the Form and I select let's say value "a", instead of showing
in textbox33 the value "a" how I want, it's shwing me the value "1", when
selcting value "b", it's showing value "2", and so on, representing the ID,
instead of the Field1 value.
What do I do wrong?
All I want is when I select value a in the combobox, to show this value in
the textbox.
The textbox is on another form, that opens after this one closes, so the
value must be ... I gues a TempVar.
Thank you very much for your help!