Filter Value from a form placed in a text box

[Musicguy2112]

I have a form called (Orders Switchboard_frm) that has a combo box (Group_cmb) with values in them. When I select a value in the "Group_cmb" combo box, a form (Requisitions_frm) opens and displays data based on the value I clicked on the combo box on the "Orders Switchboard_frm" form.
I have a button on the "requisitions_frm" called "add record" which basically adds a record to the table.
I would like to, when the "add record" button is pressed, to have the value from the "requisitions_frm" filter be placed in a field called "group" on the same form. So I came up with this easy code:



Me.Group.Value = Me.Filter

This all works very well except I get:

[Group] = 'TheTextIWant' in the "Group" field

I would like to get rid of

[Group] = ' ' and only have "TheTextIWant" part. Keep in mind that "TextIWant" is a variable

Anyone know how to do this?

[RuralGuy]

Try:
Me.Group = Mid(Me.Filter, 2, Len(Me.Filter) - 2)

[June7]

Try Replace(Me.Filter,"'","")

This assumes no other apostrophes will be encountered. If there could be and you don't want them eliminated, then RuralGuy's suggestion is the safe method.

[RuralGuy]

Another good suggestion June7.

[Musicguy2112]

Thanks alot guys! this actually worked!

Me.Group = Mid(Me.Filter, 12, Len(Me.Filter) - 12)

Much appreciated, I've been on this for awhile!

[RuralGuy]

Thanks for posting back with your success and solution.