Synchronise Main form with Sub Form

[jmeek]

I have a main form with combo box used for selection criteria. On the same form is a datasheet subform which show the records according to combo box criteria. I have also managed to insert (All) into the combo box to show all records but when I click "All" nothing happens. It does work for all other criteria in the combo box.

I attach the mdb so you can see what I have done so far.
Can anyone help me on the matter. Thanks

 

[MStef]

Hello jmeek!

You don't need two forms. Look at attachment.

 

[jmeek]

Sub/Main form

Hi MStef

Just picked up your zip file.
Your solution works. Thanks for your
help. I do however lose the datasheet
subform using your method. Trying to
simulate a datasheet will take a lifetime

Thanks