Spin buttons in sub form?

[AccessMc]

I have a form that allows users to order Stock items using a sub-form. I have a quantity field in this also. I'm trying to control the quantity using spin buttons but unfortunately I cannot make these work. I have tried placing them in the sub-form but they are never visible. Is there any way to use spin buttons to control a field in a sub-form?

Access 2003.

Thanks.

 

[missinglinq]

...I have tried placing them in the sub-form but they are never visible.

Not on a Datasheet View Form, which is what your Subform has to be, for the Control to be there but not be visible in Form View.

I suppose you could use a Continuous View Form for you Subform and tweak it to look like a Datatsheet View Form. You could then have a Spin Button visible. But to be honest, this seems like a lot of work to keep the users from simply entering a number.

Linq ;0)>

 

[AccessMc]

Okay that's not a problem. I'll leave it out - I just thought it would be a simple thing I was missing but it's not essential by any means.

Thankyou very much.