Larry,
You may need to refresh the table and/or the view. PROPERTY TABLE tablename 'REFRESH' . or . PROPERTY TABLE viewname 'REFRESH' Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Wednesday, March 11, 2009 12:49 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Refreshing a DB Grid lookup list. Here's an odd one. I have a DB Grid in which one of the columns uses the Expression tab to allow the user to select from a list of values (or they can type in their own value). That works nicely. The problem is that my drop down list is a view that is a de-duped list of the values already in the column. If the user adds a new row and types their own new value in the drop down, then adds a _second_ row and attempts to use the drop down, the value added for the first row is not yet in the lookup list. If I leave the form and come back, the new value does appear. In effect, I need to force that secret user defined drop down control in the grid to do REFRESHLIST. The list of values in the drop down is being set when the form starts and it doesn't discover my new entry until the form starts again. Can anyone suggest some clever action I can take to force the db grid lookups to initialize themself again? -- Larry
