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

  • Thread starter Thread starter nesster13
  • Start date Start date
N

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
 
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.
 
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
 
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.
 
Back
Top