Hi All,

Anyone know of some good example code of synchronising forms in ADP projects? I've got a form displaying a list of orders and a details pop up form that shows expanded details of the selected order.

I can get this to work but if if a field is changed I can't get the main list to update without doing a form requery.

If I do this two calculated fields which worked fine when the form was orginally opened display "#Error". (I'm using Access 2000 Sp3)

Many thanks
J

What are you using for recordset for the popup form?
Have you tried the refresh method instead?

Sal

I'm modifying the recordsource of the popup form to SELECT * FROM tblOrders WHERE OrderID=X, where X is the selected Order on the listing form.

I've tried requery and refresh and they do the same.

Actually, I just put a button on the main details form to requery the form and when I pressed that the two calculated fields come up with error. They were fine when the form opened up!

Cheers
J

On the after update event of the textbox that you changed, re-set the calculated field

with txtCalc 'this is the name of the calculated textbox
     .SetFocus
     .Text = "New Value"
end with

Sal