Subform freezing i Access 2003

[Flick Olmsford]

I have a client info table linked to about 20+ tables. One of linked tables
stores sales data.

I have a main form for the client info with about 20 linked tabbed subforms
to the linked tables.

The subform for the sales data table hangs when editing / entering the data.


I tried placing a command button to save the data but everything still
hangs. When I deleted it and replaced it on the form I got the message "The
DOMENU option was cancelled" (or something to that effect)

I cannot use a drop down button on the main form to search for another record.

Is there a way to find out which object in the form / event / code is
hanging the form (something like eventvwr)

I should point out that the database is not split yet and my workstation has
512 MB ram

 

[Arvin Meyer [MVP]]

I think you are exceeding the resources of your machine, and it will get
worse when you split the database and put the data on a network.

I cannot imagine any absolute requirement to use all 20 subforms on 1 main
form. I would normally think that 5 or 6 is enough. If you need to see sales
for that client, open another form to that client only:

DoCmd.OpenForm "frmSales" ,,, "ClientID =" & Me.txtClientID