Is clearing a form the same as adding a new record?

[Access_Novice]

Why or why not?



Either way, you get a blank screen.

[June7]

Depends if the form is bound or unbound. A form that has a RecordSource is bound and adding a new record takes you to the New Record row of the form's RecordSource. Any entry/edit to bound controls will pass directly to the table.

If you 'clear' a bound form by setting controls as null or empty string, you quite possibly have just wiped out data and the result will be a record with blank fields that weren't blank before.

[Access_Novice]

Depends if the form is bound or unbound. A form that has a RecordSource is bound and adding a new record takes you to the New Record row of the form's RecordSource. Any entry/edit to bound controls will pass directly to the table.

If you 'clear' a bound form by setting controls as null or empty string, you quite possibly have just wiped out data and the result will be a record with blank fields that weren't blank before.

Ok. I'm just trying to understand this better by observing the system I am using. Thanks again. You've been very helpful.