I have a DBGrid containing a drop-down column specified using the Expression tab of the Column properties.
I'm using a WHERE clause on the Expression tab to limit the user's choices. The WHERE clause is of the form "WHERE MyIDColumn = .fRCW_MyIDValue". The variable fRCW_MyIDValue is set inside the form, after it starts. The problem is that the list of values in the drop down seems to be loaded at form start-up and does not change when I change the value in fRCW_MyIDValue. If this variable does not exist at the time I start the form, no values are available in the drop down. Is there a PROPERTY command to force the grid to refresh the lookup values either directly or by tricking the grid somehow? -- Larry
