H
hydroparadise via AccessMonster.com
Can somebody help me understand the relationship of a Form.Recordset object
and its underlying Table? After some investigation, I have figured out that
a only the form's recordset is really being updated when values are updated
or added to a form except when some event or method occurs like closing the
form or using Form.Requery or Form.Refresh. Under normal cirmcumstances, all
I would have to do is either use the form's refresh method or the controls
under the control's update event to "sync" the values together, but
unfortunately I'm working with a filtered form where form.requery removes the
filter and shows all "unwanted" values for that that table/query. For some
reason, the control's requery method does't do the trick either. This
question actually stems from the following situation. I have a form thats
filtered where a user updates and adds values. I want to add a subform (or
some other method) that uses a SELECT statement with a GROUP BY clause to
summarize whats being shown in the form. As data is added, the two dont stay
in sync as I had expected it would. Now, if I'm doing something stupid, I
dont mind the flames, as long as I can get some sort of response on this
and its underlying Table? After some investigation, I have figured out that
a only the form's recordset is really being updated when values are updated
or added to a form except when some event or method occurs like closing the
form or using Form.Requery or Form.Refresh. Under normal cirmcumstances, all
I would have to do is either use the form's refresh method or the controls
under the control's update event to "sync" the values together, but
unfortunately I'm working with a filtered form where form.requery removes the
filter and shows all "unwanted" values for that that table/query. For some
reason, the control's requery method does't do the trick either. This
question actually stems from the following situation. I have a form thats
filtered where a user updates and adds values. I want to add a subform (or
some other method) that uses a SELECT statement with a GROUP BY clause to
summarize whats being shown in the form. As data is added, the two dont stay
in sync as I had expected it would. Now, if I'm doing something stupid, I
dont mind the flames, as long as I can get some sort of response on this