Result listed in textbox is different from the item shown in the drop down list

Alvin85

Registered User.
Local time
Tomorrow, 05:16
Joined
Jul 7, 2018
Messages
17
Please help me with the following problem on miscosoft access

I have a drop down list named ddl_fine with the option <$2000, $2000 but <$5000. I m using a query to populate my ddl_fine

When I use a textbox to display what i had chose, it display a single number. Example: I selected <$2000. I expected the texbox to display <$2000 but it displayed 1 instead. It is reading the row correctly but anyway to make it display <$2000 instead of 1?
 
Your combo has at least two columns.
The first, hidden, column is an ID field.
The second column is what you want.
As the column numbering is zero based, your textbox record source needs to be set using

Code:
Me.TextboxName = Me.Comboboxname.Column(1)
 

Users who are viewing this thread

Back
Top Bottom