It sound right are you issueing a Thisform.Refresh() after you get the new information?

Ron

>In a the data environment of a form I have table1 (the main table) table 2 used for a search and a local view of table 2 where view1.IDno = table1.IDno.
>This works well for the records on file at the opening of the form.
>When I enter a new record in Table 1 it finds the IDno in Table2 but the view1 does not get updated. How would I go about updating the view. I tried requery(view1) and it does not work.