Adding new record clearing the fields

[natyboi]

Good day,

I want to save record then clear the field for my next entry except for one unbound field not to be clear.?

i tried the DoCmd.GoToRecord , , acNewRec but it clears all data in my field together with my one unbound filed.

Need some help?.

[Seth Schrock]

It doesn't sound like your control is really unbound then.

One option would be to store the value in the unbound control in a variable, use the DoCmd.GoToRecord command and then reset the value of the control back to the value in the variable.

[natyboi]

ok. to simplify . i would like to clear specific field after i add data

[twinnyfo]

natyboi,

What is the purpose of keeping the one specific field's data? Are all these records related via that value? If so, then it would make more sense for your form to be set up as a Parent/Child, with the subform bound to a separate table, with a foreign key to your non-changing value of the main table. Then, every time to go to a new record on the subform, everything is cleared except for the main-form's value.

Not sure if I explained that very well. Those of us who have been doing this for a long time understand the principle, but it is all based on having tables that are properly Normalized (see this thread).

@Seth, does this sound right to you?

[Seth Schrock]

@natyboi If all (or some for that matter) of the controls that you want cleared are bound, then your only option to clear the fields without editing a record is to go to a new record. From my experience and knowledge of how things are supposed to work, an unbound control shouldn't (without other code changing the value) make the unbound control get cleared when you move to the new record. My suggestion would be to check your form's On_Current event to see if there is code or a macro that is editing the value of this control manually.

@twinnyfo You have the subform idea correct, but I'm guessing that this isn't the case here. However, I can't come up with what the case actually is either, so you might be right :)

[jimatqsi]

natyboi,
Keep in mind the before insert and after insert events on the form. You could easily put some code into the After_Insert event to clear the field.

Jim