Creating / Amending records in a form

[diasflac]

I am creating a database at the moment that needs to be so user friendly, that a monkey could use it.

I would like to separate the Amend and Create record function into two different forms.

What I mean is;

1 form to create a record - At the moment it already jumps to new record, but I would like it to be unable to scroll existing records. Limiting it's function to creating records.

1 form would be to view and amend, the opposite of the first. I would like you to be unable to create a new record and only be able to view existing records.

Currently the first form jumps to create new record but you can scroll back through records. The second form starts on record 1 with a drop down to find the record you want, but going to the end you could create a record.

Any help is appreciated.

 

[DavidAtWork]

To create records, just set the form to Data Entry in it's properties.
To edit and view, just set the form's 'Allow Additions' to NO, 'Allow Edits' to YES in it's properties

Job done

David