Textbox and its SpinControl - but i want to use both!

[James3mc]

I have a textbox (TxtPublishYear) which contains a 4 digit year. This textbox also has a SpinControl (SpinYear) which is used to increase or decrease TxtPublishYear.

The control source of TxtPublishYear is '=[SpinYear]' (without quotes)
The control source for SpinYear is 'Publish Year' (without quotes) that being the field containing the year.

I need the Spincontrol and there's some code to limit its range (not greater than current year etc.).

The spincontrol works beautifully, spinning up or down to increase or decrease the value of TxtPublishYear.

However i also want to be able to manually edit the contents of TxtPublishYear so that someone can simply type in (say) 1997 rather than spin round to it. But when i try to edit the textbox, i get the error "Control cannot be edited; it's bound to the expression 'SpinYear'"

How can i use the spincontrol to control the textbox AND be able to edit the textbox as well?

[RuralGuy]

Don't have the ControlSource of the TxtPublishYear control bound to another control. You can bind it to a field if you want.