General information
Category:
Forms & Form designer
>The RecordSource for a grid is a table. The Table contains severl fields that hold codes which don't have meaning to the end user. I have functions that translate these codes into understandable text. Those grid columns that would display the decoded informations are read only. Other columns need to be editable.
>
>I have tried putting the decodeing function as the ControlSource and putting code in the refresh for the grid's TextBox, neither work. I'm sure others do this on grids but I'm having no luck.
This where using a SQL Select statement to populate a cursor for displaying in the grid would be nice. If you need it to be updateable you could create a local view. Parameterized, probably.
Or, you can display the related fields in comboboxes in the grid, if you want to let users pick values based on the human name and not the code. This works alright, but combos in grids *can* slow things down. And you have to remember to set sparse = .f.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only