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.

Thanks in advance
Raymond