Limit (part of) Form to entrance of new data only? (1 Viewer)

[David8]

I am an Access beginner, particular with forms.

Ideally, I would like to create a split view form. The lower section datasheet view will get used for editing existing records, and...

key point: data entered in the upper form section would not accidentally ammend any existing record, but WOULD ALWAYS BY DEFAULT CREATE A NEW RECORD with the values specified.

So, top part for new records, bottom part for ammending and viewing existing data.

Can anything like this be done?

 

[SpentGeezer]

I am an Access beginner, particular with forms.

Ideally, I would like to create a split view form. The lower section datasheet view will get used for editing existing records, and...

key point: data entered in the upper form section would not accidentally ammend any existing record, but WOULD ALWAYS BY DEFAULT CREATE A NEW RECORD with the values specified.

So, top part for new records, bottom part for ammending and viewing existing data.

Can anything like this be done?

Try this to get you started: