formula in a control source

[jaybo]

I have a formula "HB" & [autonumber field] & "05" to create a number for my record ie HB105. I want this number to save into my autonumber field. where could I enter this formula so that when a user enters info in the record its saved in that field ?

 

[FoFa]

You can not save to an autonumber field.
Create a column (text) and use a formula to create this value from other columns.

 

[jaybo]

Thanks I should have known that my brains not working today !

One more thing - To save my value from the text box called HB# into a field, any advice ?

Thank you so much.