>What would make your grids not refresh with you have already do a ThisForm.Refresh
>on a LostFocus of the Key field?
>
>They are not retreving the correct information from there perspective tables.
>example:
>
>Keyfield:[CID] =100
>
>gridtable1,2,3 should display record data for records related to CID 100
>it should change when you change the Key[CID] to another value
You may be changing the value of the key, but are you doing a requery() if the source is a view? If a table, are you doing a seek or some other comparable action to move the pointer to the new record?
You say grids. Is this like a parent and child grids? If so, are you setting the LinkMaster, ChildOrder and RelationalExpr properties on the applicable grids?
Mark McCasland
Midlothian, TX USA