Events Confusion?

[homerj56]

Access 2003. I have a continuous form (form_1). On the continuous form I have a cmd button to open another form (form_2 for adding new records). Form_1 query is based on form_2 query.

When I am finished adding the new record, the EXIT button on form_2 takes me back to form_1. However, the new record does not display unless I exit/return form_1 or run a filter/sort on form_1. I have tried to requery the underlying data (for both form_1 and form_2 but no way can I get form_1 to update as soon as I return to it. I've tried a variey of events but no avail.

Any suggestions are appreciated.

[weekend00]

on the event of form_close of form_2, add following codes:
forms!form_1.requery

[homerj56]

on the event of form_close of form_2, add following codes:
forms!form_1.requery

Nope, form_1 is still showing the previous records and doesn't display the newly added until I sort/unsort, close, open, etc.

[weekend00]

then you can sort them so that the new record will be shown.

[homerj56]

then you can sort them so that the new record will be shown.

Defeats the purpose, doesn't it? Are you telling me that Access cannot update the "calling" form automatically without the user having to sort/resort the data? What good is is the forms! requery command? Does this probelm have anything to do wit the fact that form_1 is a continuous form?

UPDATE:My bad. I was requering the wrong query. Thanks - works.

[weekend00]

Generally, requery should refresh the records. but in your case, i am not sure what is behind this to make it doesn't work.