How can I prevent certain fields from refreshing when submit is clicked

[nesster13]

I have a form with about 20 fields and this form is bind to a table
where when I click submit, the data from the from will be saved to the
table that it binded to. Now there are certain fields that I do not
want to refresh when I hit submit. Is there a way to preserve the value
in these fields? These are Combo boxes by the way. Thanks

 

[Steve Schapel]

Nesster,

Can you please explain what you mean about "refresh"? What is actually
happening with your 'Submit' button? THis is unusual, because a record
is normally saved to the table when the form is closed, or when you move
to another record, so there is normally no need to "click submit", so I
can't quite figure out what you are doing.

 

[nesster13]

Thank you for replying to my post. This is the scenario. I have a form
with about 4 combo boxes and the rest are text boxes. There is a submit
button on the form which when I click it all the information enter on
the form will be append to a table on the database. What submit also do
is clear out all the information on the form, same like reload the form
with all empty cells. What I would like to do is once I submit/save the
data; the form will still reload but the values in the combo boxes
prior to submitting the form would still be there, not to refresh/clear
the combo boxes. Thanks

 

[Steve Schapel]

Nesster,

Do you mean it is an unbound form, with unbound controls? So you are
entering data into unbound controls on n unbound form, and then click a
button and these values are appended to the table? If so, I am not sure
why you are doing this way, rather than entering directly to a bound
form, which would be easier. But anyway, when you say you "clear out
all the information on the form", how is that happening? Is there a
macro or VBA procedure that does this? If so, I guess your question
relates to modifying this process so that not all of the controls are
reverted to null.