Tabbed Subforms

[ThePhantom]

Hi,

I have a form with a tab control having around 10 pages. Now each page has a subform creadted by clicking "Insert Subform", which is nothing but a form defined on a table to the main.

My issue is that I want the subform to display only records corresponding to the value of an unbound combo box (Patient ID) selected in the form. However, although I have set the "Link Master Table" to the value of the unbound combo box, the relevant values are not reflected in the subforms.....

Any help is appreciated. Thanx a lot.

 

[maxmangion]

the last time i used something similar, i did the following (however i am not sure if it is the best way):

i created a query and in the field which i want to limit the records by i placed the following [Forms]![FormName]![NameofUnboundCombo]

Then in the tab formed i placed the subform and in the source object i selected the name of the query!

note that you should requery the subform in the after update of your combo box!