Recent content by JeffB

Hi Gemma. Yes, you described my problem. Any ideas for a solution?

Actually....I take that back. Neither the Recordset or the RecordsetClone have been updated. The RecordsetClone was at position 0 and had similar data to the record I modified at position 4. So I mistakenly thought RecordsetClone had gotten updated. It did not. So now my question is WHY ISN'T...

I just made a very interesting discovery. After my Form2 closes and updates the table, Form1.Recordset property does not show the change. But Form1.RecordsetClone DOES! Why is this? How can I get the changes in RecordsetClone to show up in the continuous form?

Hi namliam. I am not seeing the original source recordset update. I think it might be because of the nature of my data source. Here is what I have: Form1 - continuous form. Data source is an existing query that inner joins a really large table with a smaller transaction table. Form2 -...

I thought about manually updating the fields in the continuous form because I have the new values entered in the second form. My guess is that would update the fields for every record in the continuous form though. Is it possible to manually modify the Recordset (or RecordsetClone?) with the...

That is exactly what I want to do - update the current record. The underlying data has already been updated via the other form. Now I want to refresh just the current record instead of requerying the entire dataset because that takes a while.

All I want to do is refresh the current item (underlying data was changed by the other form). I don't want to requery the entire record set because it takes too long and I know the only thing I changed was data shown on the current record. Calling Refresh doesn't do anything though. I am...

I am using Me.Refresh. It does not seem to do anything. Could it be because the Form's record source is a query, while the second form updates a table in that query?

Hello All, Is it possible to Refresh a Continuous Form without Requerying the entire data set? Here is what I am trying to do, I have a form that displays records in a Continuous form. The data source is an existing query that joins a few different tables. It takes a while to run (20 seconds...