Showing filter criteria on form

[branston]

Hi,

I have a form (a) where I select an option from a ComboBox which then opens another form (b) filtered for the ComboBox selection.

On the form b I have another combo box with the same options as the one on a (i.e. so you can open the form for a certain selection, then change the selection without going back to the form a)

What I want to happen is that when form b opens, its combo box is automatically populated with the selection from form a (i.e. whatever form b is filtered for)

I was hoping to be able to do this very simply without having any variables stored between forms etc...

I got part way using:
me.ComboBox = me.filter

but that brings up the whole filter criteria (e.g. [MonthName] = November) whereas I just want it to say "November"

Any ideas?

Thank you

 

[DCrake]

On the OnLoad of FormB

Me.ComboSelection = Forms("FormA")("ComboBox")

 

[branston]

Brilliant. Thank you!