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

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
-- 
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Flick Olmsford" <FlickOlmsford@discussions.microsoft.com> wrote in message 
news:E206AB47-37B2-40D6-BCAF-B6253C4FE06D@microsoft.com...
>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
>
>
>
>