ControlSource Subform within Tab Page

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

I hope this is a relatively simple question

I have a form that has 8 tabbed pages. On each page I have included a
subform(same subform on each page just different filered results on a single
table)

Can I re-use the same subform repeatedly and if so how do I cause this to
requery on selection of another tab ??

Sorry if this is simple, but have been scratching my head for what seems a
long time now

--
Many Thanks for any suggestions

Regards

Alan
 
Damon

I understand what your are hinting at, but the format of the Form is to use
tabbed pages whith the potential for other pages being added.

This is a request from others who use my Db and wish to keep it simple from
their perspective. It currently works using tabs and multiple queries,
however there is a desire to use colours on the rows of the form and hence
the use of a continuous sub form
 
Damon

Once again thanks for the update. In danger of being a pest, can you tell me
the VBA for assigning the controlsource

I have tried a variety of combinations, however appear to be getting
something wrong !!

Forms!sfrmUpdate.ControlSource =""

doesnt appear to work in the change event ??
 
Back
Top