Brother star 110 stitch selector will not turn

Te 'handwheel' is the top knob on the right.
The 'Pattern Selector Dial' is below it.

If you are using that dial and it isn't changing the stich, it must have become disconnected inside.

https://www.manualslib.com/manual/483895/Brother-Xl-3200.html?page=16#manual

https://www.google.com/search?q=brother+xl-3200+only+straight+stitches

..

Check that the button hole lever is not somehow stuck in the back position.

Set the machine to the widest stitch width available and measure the stitch. A maximum stitch width of 5mm will tell you that you need the narrower walking foot.

Hope I'm not stating the obvious, but have you tried Brother ? I've dealt with them often in Canada and their service has always been terrific. Worth a try if you haven't tried it.

Site here, just pick your country.

http://support.brother.com/g/b/countrytop.aspx?c=ca&lang=en

Perhaps the owner's manual will be helpful:
https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=5&cad=rja&uact=8&ved=0CDcQFjAEahUKEwj8zr2ZsfzIAhUVzWMKHZnKD60&url=http%3A%2F%2Fdownload.brother.com%2Fwelcome%2Fdoch000287%2Fstar110130eom01enes.pdf&usg=AFQjCNF-T2RA_sAcLvzIXdfX_iWt_ulkfw

Here's a response to a similar problem posted on Fixya:
Brother star 110 stitch selector will not turn

This appears to be a mostly electronic/computerized machine so problems could very well be a result of computer or software failure.

Brother Dealer will order for you

Stitch length on 2.5 and stitch width on zero, and just loosen the top tension by a half number if you want the tension looser. If your machine has a stitch selector knob, make sure it is set to the straight stitch setting.

Try http://www.brother-usa.com/modelDocuments/Consumer/users/%20Manual/UM_XL.2600i_ENES_1478.PDF Jimy

Throughout the Swiss Elna range there were several of their top of line models that have the black cams for additional stitches and they all have an "Elnagraph" device in the top of the machine case where you insert the cams.

There are single cams where the needle just moves ffrom side to side while the fabric moves forward. And double cams where the needle moves from side to side while the feed dogs move the fabric forward and backwards to get a combination stitch. The trick is to get the Elnagraph to engage so the arm in it can "read" off the disc.

There are a couple of other knobs that you need to adjust to get the cam stitch though.

Star Series: (white machine with blue top) you need to put the stitch selector inside the elnagraph flap to "A" on the Star series and then stitch width to 4 and stitch length to the red A zone.

Air Electronic SU or Carina: you have 3 knobs from left to right - stitch selector (put it on 7) , stitch width (put it on 4, orange area) and stitch length (turn it around to the orange zone for the automatic stitches).

And on the early Supermatic the adjustments are a little different again.

And ALWAYS turn the stitch width and length dials back to zero, before you change the stitch selector, or pop out a cam.

I hope this helps you get your Elna stitching from the cam, there is a great Yahoo group called Elna Heirlooms too where there are lots of knowledgeable Elna owners and some files listing all the cam stitches.

Had the same problem - found the manual under different country from their website:
http://welcome.solutions.brother.com/BSC/public/files/dlf/doch000287/star110130eom01enes.pdf