a sub form on 2 forms

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

I have one sub form on the 2 forms, because they have similar
functions and data.

The problem is if 2 forms show at same time the sub form only shows on
the first form.

Are there working around for this or I missing anything here or I must
have 2 different sub form on 2 forms even they have similar functions?


Your help is great appreciated,
 
That's the correct behavior. If you could open the same subform twice, it
would be easy to have a data conflict as you try to enter different data at
the same time.

Create a copy of the subform with a new name and use it.
 
iccsi,
Hard to say for sure, Access could be having unpredictable problems
by having the same form opened twice, in one "instance.".
I would make a copy of subform1 and give it a different name.
If, for example, one main form is frmOrders and the other is frmReturns,
then I'd name the subs...
frmOrdersSub
and
frmReturnsSub.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
That is the correct behavior if you're opening the forms in design view. But
in operation, I don't have any problems when the same subform is used on two
different main forms. I can open both main forms at the same time and
everything works fine in both forms. If you're having problems in form view,
maybe start by disabling any code that works with the subforms and make sure
it displays data ok. If so, then check for any code that might reference the
subform via a specified main form rather than using the subform control name
to get to the subform.
 
That is the correct behavior if you're opening the forms in design view. But
in operation, I don't have any problems when the same subform is used on two
different main forms. I can open both main forms at the same time and
everything works fine in both forms. If you're having problems in form view,
maybe start by disabling any code that works with the subforms and make sure
it displays data ok. If so, then check for any code that might reference the
subform via a specified main form rather than using the subform control name
to get to the subform.








- Show quoted text -
Click to expand...

Thanks millions for the information,
 
Back
Top