Filtering 2 forms at once

[TheClaw]

OK Guys.... I really need your help. I have a form with various filter options on using combo boxes and I have a subform which I wish to disply the same results but in datasheet view. How do I make the datasheet version reflect the filters applied on the main form?? Please please help!!!

Some code would be much appreciated.

Ben

 

[JoeMiller]

Do you requery the subform after updating the combo box?
[tt]SubformObjectName.Requery[/tt]

Is the query criteria feeding the subform set to look at the main form combo boxes?
[tt][Forms]![MyFormName]![MyComboBoxName][/tt]

HTH Joe Miller
joe.miller@flotech.net

 

[TheClaw]

It is looking at the combo boxes but it only displays the record the main form is on even though there are i.e. 101 filtered records. I dont know how to get around this.

 

[TheClaw]

....when I do the above link it says "invalid outside procedure".

 

[vickvickvi]

hello, this is Vickvickvi, the best thing I can tell you is :

1: Set the Subform as a datasheet Only using the form property's on the subform.
2: in the main form, change the parent/child to the link or links.
Ex:
link child fields: subfield1,subfield2
link master fields: fieldname1,fieldname2

3: on change of the combo box , requery the subform.

 

[TheClaw]

I can't find form property's on sub form and link the master and child together causes the datasheet to display the current form record and not all filtered records.

Thanks anywayzzz

 

[TheClaw]

I guess no one knows?? It seems to filter when the form is loaded seperately but not in a sub form