I have probably done this several times before, but for some reason I cannot remember
how nor get this to work... a simple function, but it is Monday.... I have a simple form with a DB grid. The form and DB grid is based upon a VIEW. The form is called via a form EEP : brow USING DevItemReserve WHERE currentitem = .vItem and serial# in + (Select Serial# from skiddata where item = .vItem and onhold <> 1) The DevItemReserve form has a button that can place the ONHOLD value = 1 in SkidData for the highlighted row being displayed. This all works as desired except I want to refresh the form/DBGrid so that selected row does not show anymore. Form A has an button eep that issues the above browse command. This lists the rows of data that is not reserved (Onhold <> 1). The user can highlight a row and push a button which updates the ONHOLD value in SkidData to 1 for that row. The DB grid ID is ItemList I now want the form to refresh and not show the just updated row. I have tried several iterations of PROPERTY posts, refresh, refreshlist, etc. etc. but am missing the correct one. Remember, the form and DB grid is based upon a multi table view. The where clause, however, has the table that is updated. Don't know why I cannot get this... mark it to Monday. Thanks, -Bob
