text box content display

[hawg1]

Hi,

Need help with text box issue. I have a form with a combobox that allows the user to select Monthly, Quarterly, Semi-Annual, or Annual. The resulting selection is stored in a field called timeframe on a table called Personnel; but the stored data is a number (1,3,6,12 respectively).
On a different form, I wish to display the content of field timeframe from table personnel but display the text equivalent, not the number.

For example, user selects Quarterly from the combobox. The value "3" is stored in field timeframe on table Personnel. On form flight chief, I wish to have the textbox frequency retrieve the content of field timeframe but display the text equivalent; in this case "Quarterly"

Any suggestions? Everything I have tried always returns the numerical value not the text.

Thanks Hawg1

 

[kabz]

why cant you just replace the Numbers with the text in your ComboBox

 

[Dom DXecutioner]

Hi,

Assuming your combobox is bound to column 1 and the first field is the numeric portion and the second the caption text, you can try...

     With Me
          .theTextBox = .theComboBox.Column(1)
     End With

Or you can just set the column widths to 0 to hide the bound (first) field, leaving only the text for display...

 

[hawg1]

I use the numbers in calculations for date intervals at other text boxes.

 

[hawg1]

Dom DXecutioner,

Thanks for your suggestion. I did some research reading and find a method that works great. Thanks for your help though.