I have a form which I want to make a connection in a field like this: If value input = X, returns AA in other text box in same form, if value = Y, returns BB. X, Y and AA, BB are in two different forms. I tried put macro Action = Openform, next Action = SetValue for the related fields, it opens up the required form, but I have to manually close the opened form before the value I wanted can be displayed. Any suggestion from anyone please?

[This message has been edited by yimlingyu (edited 12-07-1999).]

[This message has been edited by yimlingyu (edited 12-07-1999).]

You need a macro with the action "Refresh" at the end. The refresh action will do the same as going out of the form and coming back in without ever leaving the form.