Thanks for the tip, PCD. I'll give it a try. At this point, all I've
tried has gotten me nowhere. I did look up this Access 2.0
help blurb. It seems to suggest that I can use the Requery
method with subform controls. But I'm not having any luck...
Requery Method
See Also Example 2.0
Applies To
Forms. Controls (combo boxes, list boxes, subforms/subreports).
Description
Updates the data in a specified form or in a control that is on the
active object by requerying the source of data of the form or control.
Syntax
objectname.Requery
Argument Description
objectname The name of the form or control you want to update.
Omit this argument to requery the source of data of the active object.
Remarks
Use this method to ensure that the form or control displays the most
recent data. The Requery method does one of the following:
Reruns the query on which the form or control is based.
Displays any new or changed records or removes deleted records
from the table on which the form or control is based.
Controls based on a query or table include:
List boxes and combo boxes
Subform controls
OLE objects, such as graphs
Controls containing aggregate functions such as DSum
If the specified control isn't bound to a field in a table or query,
this method forces a recalculation of the control.
If you omit objectname, the Requery method has the same effect as
pressing SHIFT+F9 when a form or control has the focus (it requeries
the underlying tables). If a subform control has the focus, this
method requeries only the source of data of the subform.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Sun, 25 Jul 2004 02:17:21 GMT, "PC Datasheet" <no****@nospam.spam>
wrote:
>Forms!frmBrowseNegsSubform.RecordSource = MySQL
Two problems here:
1. A subform is not part of the Forms collection; it belongs to the main form's
collection. You need to reference the subform like this:
Forms!NameOfMainForm!frmBrowseNegsSubform.Form
2. A subform control does not have a recordsource property! The form in the
subform control does though. Try:
Forms!NameOfMainForm!frmBrowseNegsSubform.Form.Re cordSource = MySQL
>Me!MySubformControl.Requery
You can't requery a subform control either but again you can requery the form
the control holds:
Me!MySubformControl.Form.Requery