Form deleting records on exit & manual to Autonumber id, HELP PLEASE!

[WillJ]

Hi All,

I have a bound form which is has bound cells and combos to the required fields. I have an 'Add Record' button and a 'Clear Fields' button.

Underneath this I have an unbound subform, showing all requests; by unbound I mean I haven't related anything when I placed the subform of the form.

When I open the form, automatically the first record is in the fields and requires me to clear the fields before I enter new details. I have written on click event me.cboEmployeeID = "", for all the fields on the table (not including the sub-form).

• The problem then occurs when I exit, the record previously cleared from the cells is deleted. Does anyone know how I can get around this?

Also I had collated a normalized the data for my data base before I transferred it across. In the ID field I simply used a number i.e. 1, 2, 3. This means that I need to know/see what the last record number is before I can manually enter the correct number.

• Does anyone have a solution how to convert a manual id to an auto number, keeping relationships in tack, or create some code that will automatically assign an id number to the required input field upon entering.

Thanks in advance ! ! !

 

[RainLover]

Create a New Field for Autonumber and use that. You can rename it to the original once you have deleted the current Field.

You Data is missing because you delete it.

To add more records go to a new record. You can use the Navigation Buttons at the bottom of the Form or create your own with a command button.

There is no need to use a Save button. Access does this automatically when you leave the record.