How to allow additional information to be put in to a text box afterdata brought in from a combo?

[David]

Hello, I need help in being able to type in additional information to
a text box that I brought in information through a combo box without
that additional information going back into that table. How do I
change the text box from bound to unbound after I get the information
in it from the combo box so that any additional information put into
the text box field will not go back to the table I got the information
from in the combo box? Thanks for any help. David

 

[fredg]

Hello, I need help in being able to type in additional information to
a text box that I brought in information through a combo box without
that additional information going back into that table. How do I
change the text box from bound to unbound after I get the information
in it from the combo box so that any additional information put into
the text box field will not go back to the table I got the information
from in the combo box? Thanks for any help. David

Well, you can't have both. It's eitehr bound or it's not bound.
Just use an unbound control (in addition to the current bound
control).
The bound control just shows the data from the combo box, and that
data is saved in the table.
The Unbound control shows the data from the combo box plus whatever
other text you concatenate into it.
I suppose you could use the combo box AfterUpdate event. Something
like this:
Me.[UnboundControlName] = [ComboBox] & " " & "Additional text"

You have given very little information with this question.
Where does the additional text come from?
Under what circumstances?
Why? If the combined data is not saved what do you intend to do with
it, as it's gone as soon as you close the form?

 

[David]

Hello, I need help in being able to type in additional information to
a text box that I brought in information through a combo box without
that additional information going back into that table. How do I
change the text box from bound to unbound after I get the information
in it from the combo box so that any additional information put into
the text box field will not go back to the table I got the information
from in the combo box? Thanks for any help. David

Well, you can't have both. It's eitehr bound or it's not bound.
Just use an unbound control (in addition to the current bound
control).
The bound control just shows the data from the combo box, and that
data is saved in the table.
The Unbound control shows the data from the combo box plus whatever
other text you concatenate into it.
I suppose you could use the combo box AfterUpdate event. Something
like this:
Me.[UnboundControlName] = [ComboBox] & " " & "Additional text"

You have given very little information with this question.
Where does the additional text come from?
Under what circumstances?
Why? If the combined data is not saved what do you intend to do with
it, as it's gone as soon as you close the form?

Hi Fred, thanks for responding. I have never done this action before
where I drop information in from a combo box, and then put additional
info. in the new record in the third field; txtDiagSpecsNewInj. This
is where I need to allow the dr. to change or add info. in the new
record. Maybe my query is not set up correctly. I have the main table
for the new records, and also the static table for the drop down combo
linked in the query.