tables and updating question???

[paulmcdonnell]

I have a query which updates prospects in distribution lists.

When the query runs it creates a new distibution list as a consequence of updating the prospects table because of the relationships between the tables

My problem is is that I use a form to create a new distibution name, this then creates a table of this name an holds the reference of the prospects within it.

I then want to add details of information about the newly created distribution list by opening a form with its recordset set to the distribution lists table

I try to open the form using the UniqueID of the newly created distibution list table entry

The form doesn't open with the appropriate record. This is not a problem of the form set up.

If I view the forms record source the newly added record for the distribution list doesn't appear. If I open the table then it does appear.

Does adding entries this way require that the table be refreshed. Its as if the record is created but the table isn't refreshed when the form calls on the data.

Requerying the form doesn't work...
anyone have any ideas

Cheers
Paul