Autopopulate NOT allowing overwrite

[ChrisCione]

I have several unbound text boxes on a form with the following controlsources:

=Classification.Column(1)
=Classification.Column(2) and so on.



I've discovered that this method, in essence, locks the textbox and doesn't allow any entry at all.

Any suggestions?

[weekend00]

what do you want?

[ChrisCione]

what do you want?

To be able to write data in the textbox if necessary.

[weekend00]

leave them as unbound(delete =Classification.Column(1) ), set default value if needed.

[ChrisCione]

leave them as unbound(delete =Classification.Column(1) ), set default value if needed.

This defeats the purpose.

Any other suggestions (from anyone), or is it just not possible to set the controlsource but also allow for overwriting with values?

[weekend00]

you may set default = Classification.Column(1)
I am not sure what Classification.Column(1) is. if this can not be set as default, you need to set it in some event for example form_load.


once you set the textbox = something, that means you bound it to something unupdatable, hence you can not change it.

[ChrisCione]

you may set default = Classification.Column(1)
I am not sure what Classification.Column(1) is. if this can not be set as default, you need to set it in some event for example form_load.


once you set the textbox = something, that means you bound it to something unupdatable, hence you can not change it.

I was afraid of that, but I was hoping that someone know a work-around.

Thanks.

[pkstormy]

You can always populate the value when the form opens or based upon a button's OnClick.
ie.
me!MyUnboundField = me!Classification.Column(1)

But as weekend00 pointed out, if you use an expression in the controlsource of a field, you cannot then edit the value in that field. The controlsource must be blank (ie. unbound field) and you must populate that value either in code or via setting the default value.

[RuralGuy]

Maybe the question we should be asking is why are the TextBoxes unbound? You obviously are attempting to fill them from your ComboBox but then you want the user to be able change the value of a basically *display textbox*. What is the reason for that?