>Hi all!
>I have two tables:
>
>Ships
>-----
>ID
>ShipName
>
>Projects
>--------
>ShipID
>ProjectName
>
>and relation between them: Ships -> Projects on ID=ShipID
>
>Also I have data-editing form. One text field (Text1) on it has a ControlSource property set to "Ships.ID" and another read only field (Text2)with "Projects.ProjectName" ControlSource property.
>
>When I change the value of Text1 field, value of the Text2 field stays the same. When I do the same one more time, value of Text2 changes. I tried Text2.Refresh and Form.Refresh methods but it didn't help.
>
>Table "Ships" is in the optimistic table buffering mode.
>
>What's the problem? I don't know. I need some help.
Eugene,
Your problem might be related to where you're refreshing it. Try to add :
with this
.Value = .Value
endwith
Before refresh.
Cetin