Combo box to report

[cmfog]

I have a combo box in my form where I have 4 options to choose from. Then when I send my form to my report it is appearing as a number. If anyone knows how to change that numerical value to the text value that I have in the combo box that would be great. This is what I have so far

=DLookUp("Field","Table","ID = ")

 

[pr2-eugin]

Would Autofill option be helpful for you?

 

[cmfog]

Well I can get it to turn to text but it only chooses the first row value not the value that I select from the combo box in the form

 

[pr2-eugin]

If you actually checked the link you would not even need the DLookup.

 

[cmfog]

That did not work