Update listbox\textbox\Combobox (use which one?)

[cjsorel]

I am not sure which one of these to use for a form where I do not want a user to change it. Code will change the value. Basically the field is Status which is stored as a number and I want the field to show only the description.

I have tried a number of ways but can not get it to work beyond the first record. Right now I have it set as a listbox with the Row Source set to a query. The query is Field Status and Status ID, for Status ID I set the Criteria to [Forms]![Contract_Register]![txtStatusID]

txtStatusID is a text box on the form to know what the status is currently set to.

Thank you in advance

 

[Darrylles]

Hi,

Apart from 'I cannot get it to work', you haven't specified your problem.

What exactly do you want IT to do?

If you want to stop the user changing it, then use the 'enabled' property.
If you are getting both fields displayed when you want only one displayed in the listbox/combo etc then either change the query to 'show' only the field that you want, or change the 'column-width' property to 0cm for the column that you don't want to see.

Kind regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[cjsorel]

Well I guess I did not come right out with a question. So here is my question. How to get a textbox to represent a description for another field? For instance if the status is 2 and that means Active.

If I use this as a list box and set the Column Widths to 0";1" I see my description without the id(number). And then set Enabled to No... then there are scroll bars I can not disable and the label is grey out.

 

[Kherozen]

Well if you do the same thing that you are doing with the listbox but with a combobox you should get the desired result


jul ^_^
"Computer Science is no more about computers than astronomy is about telescopes"
E. W. Dijkstra.