Hi!
I guess this is related to swicthing between data sessions, if another form uses another data session (private data sessions thing).
Are you sure relation is not broken for duration of another form running?
Why not make a query from two tables into a single cursor s you will have everything in a single record source?
>I have a grid on a form with "table1" as RecordSource .
>I set a column with a ControlSource like this:
>
>IIF(EMPTY(table2.item_code), ' ', '#')
>
>table2 is related with table1 based on item_code.
>When I activate another form (the form with the grid looses focus)
>I have a "total" refresh of the column grid with the same value
>(' ' or '#' depending on the value of the current grid row)
>
>Any suggestion ?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.