Refreshing records on a continuous form
Posted on 1999-07-27
I'm just Mr. Question today :-)
I have a continuous form showing a list of call list records (currently 13 of them). I have a button on the header of this form that opens another form which allows me to enter a new record, runs an append query to add it to the records and closes the 'add new record' form, so the focus is back with the original call list form. However, the number of records has not changed. If I add a 'me.refresh' after the sub form has closed, I still don't get the new record. If I go into design mode and back to preview mode, I still don't get the new record. If I shut the form and re-open it, THEN I get the new record. The record source for the form is a simple query that has two tables in it: the one I'm updating (call list) and a list of Caller's names (caller names) that's linked by Caller ID. The query is not just specific to the form, it exists in the 'query' windows as well. How come the 'refresh' doesn't work and I only see the new record if I close and re-open the form?