I have a form with a subform that it used to enter ECOs (Engineering Change
Orders). On the form, when the user selects the option "Type 5" from a
combobox, a popup form is displayed in which the user will enter information
to run two queries. The first query, a select query, takes the user input and
returns records that meet the criteria. The second query is an append query
that takes the information from the select query and appends it into a table
used by the subform on the mainform. The select query is closed upon the
append query completion and the user then clicks the exit command button to
exit the popup and return to the mainform. At this point the subform is
automatically refreshed.

This all works fine; the subform shows the newly appended data. However, I
receive the error "There isn't enough free memory to update the display..."
and some of the text on the form displays weird and the only way to get the
text to display correctly is to exit the database completely and restart it.
This error shows on others PCs as well.

The error seems to be tied into using acDialog for the popup. I use acDialog
to freeze the code until the queries are run so that the refresh of the
subform works. If I remove acDialog and use a command button on the form to
refresh the data I do not get the error.

Is there a way to not have this error come up while using acDialog?

Code on main form:
Private Sub cboEcoType_AfterUpdate()
' Open Component Family entry form if user selects Type 5 from combo box.
Dim strType5 As String
   strType5 = "frmCompFamilyEco"
   
   Me.sbfDwgRevs.SetFocus
   
   If Me.cboEcoType.Value = 5 Then
       DoCmd.OpenForm strType5, , , , , acDialog
       Me.sbfDwgRevs.Requery
       
   End If
   
End Sub

Users  are running either Access 2K with SP3 installed or Access 2003 (error
shows for both). Database is split into a front and back end and run from our
company intranet.

If any other info is needed to help, please let me know.

Thanks!