>I am having a bit of a problem with refreshing a view - hopefully someone can help. DESIGN is my table name and DESVIEW is my view name.
>
>I have an order entry form that has two different entry points to another form where the user can enter a new product. Entry point A calls design form which calls descode form. Entry point B calls browsemulti form which calls customergoods form which calls design form which calls descode form.
>
>design form calls descode form which actually does an INSERT to the table DESIGN. When it returns back to the design form, it does a SELE desview, then a REQUERY('desview'), then another SELECT desview. The very next statement is a LOCATE FOR to find the newly added product. When running this code from entry point A, everything works fine. When running from entry point B, the locate does not find the new record.
>
>I have no idea where to start looking. I have tried doing refresh in addition to requery and removing one of the selects, but nothing seems to work.
>
>Any help is greatly appreciated.
>
>Randy Wessels
Randy,
Have you confirmed that the ID you are locating is correct?
If you do a brows on the View and table is the new record available in both?
Caroline